Northwind › Views
Alphabetical list of products view
69 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued | CategoryName |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Chai | 1 | 1 | 10 boxes x 20 bags | 18.0 | 39 | 0 | 10 | 0 | Beverages |
| 2 | Chang | 1 | 1 | 24 - 12 oz bottles | 19.0 | 17 | 40 | 25 | 0 | Beverages |
| 3 | Aniseed Syrup | 1 | 2 | 12 - 550 ml bottles | 10.0 | 13 | 70 | 25 | 0 | Condiments |
| 4 | Chef Anton's Cajun Seasoning | 2 | 2 | 48 - 6 oz jars | 22.0 | 53 | 0 | 0 | 0 | Condiments |
| 6 | Grandma's Boysenberry Spread | 3 | 2 | 12 - 8 oz jars | 25.0 | 120 | 0 | 25 | 0 | Condiments |
| 7 | Uncle Bob's Organic Dried Pears | 3 | 7 | 12 - 1 lb pkgs. | 30.0 | 15 | 0 | 10 | 0 | Produce |
| 8 | Northwoods Cranberry Sauce | 3 | 2 | 12 - 12 oz jars | 40.0 | 6 | 0 | 0 | 0 | Condiments |
| 10 | Ikura | 4 | 8 | 12 - 200 ml jars | 31.0 | 31 | 0 | 0 | 0 | Seafood |
| 11 | Queso Cabrales | 5 | 4 | 1 kg pkg. | 21.0 | 22 | 30 | 30 | 0 | Dairy Products |
| 12 | Queso Manchego La Pastora | 5 | 4 | 10 - 500 g pkgs. | 38.0 | 86 | 0 | 0 | 0 | Dairy Products |
| 13 | Konbu | 6 | 8 | 2 kg box | 6.0 | 24 | 0 | 5 | 0 | Seafood |
| 14 | Tofu | 6 | 7 | 40 - 100 g pkgs. | 23.25 | 35 | 0 | 0 | 0 | Produce |
| 15 | Genen Shouyu | 6 | 2 | 24 - 250 ml bottles | 15.5 | 39 | 0 | 5 | 0 | Condiments |
| 16 | Pavlova | 7 | 3 | 32 - 500 g boxes | 17.45 | 29 | 0 | 10 | 0 | Confections |
| 18 | Carnarvon Tigers | 7 | 8 | 16 kg pkg. | 62.5 | 42 | 0 | 0 | 0 | Seafood |
| 19 | Teatime Chocolate Biscuits | 8 | 3 | 10 boxes x 12 pieces | 9.2 | 25 | 0 | 5 | 0 | Confections |
| 20 | Sir Rodney's Marmalade | 8 | 3 | 30 gift boxes | 81.0 | 40 | 0 | 0 | 0 | Confections |
| 21 | Sir Rodney's Scones | 8 | 3 | 24 pkgs. x 4 pieces | 10.0 | 3 | 40 | 5 | 0 | Confections |
| 22 | Gustaf's Knäckebröd | 9 | 5 | 24 - 500 g pkgs. | 21.0 | 104 | 0 | 25 | 0 | Grains/Cereals |
| 23 | Tunnbröd | 9 | 5 | 12 - 250 g pkgs. | 9.0 | 61 | 0 | 25 | 0 | Grains/Cereals |
| 25 | NuNuCa Nuß-Nougat-Creme | 11 | 3 | 20 - 450 g glasses | 14.0 | 76 | 0 | 30 | 0 | Confections |
| 26 | Gumbär Gummibärchen | 11 | 3 | 100 - 250 g bags | 31.23 | 15 | 0 | 0 | 0 | Confections |
| 27 | Schoggi Schokolade | 11 | 3 | 100 - 100 g pieces | 43.9 | 49 | 0 | 30 | 0 | Confections |
| 30 | Nord-Ost Matjeshering | 13 | 8 | 10 - 200 g glasses | 25.89 | 10 | 0 | 15 | 0 | Seafood |
| 31 | Gorgonzola Telino | 14 | 4 | 12 - 100 g pkgs | 12.5 | 0 | 70 | 20 | 0 | Dairy Products |