Northwind › Views
Order Details Extended view
2155 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
| OrderID | ProductID | ProductName | UnitPrice | Quantity | Discount | ExtendedPrice |
|---|---|---|---|---|---|---|
| 10801 | 17 | Alice Mutton | 39.0 | 40 | 0.25 | 1170.0 |
| 10852 | 17 | Alice Mutton | 39.0 | 6 | 0.0 | 234.0 |
| 10861 | 17 | Alice Mutton | 39.0 | 42 | 0.0 | 1638.0 |
| 10871 | 17 | Alice Mutton | 39.0 | 16 | 0.05 | 592.8 |
| 10890 | 17 | Alice Mutton | 39.0 | 15 | 0.0 | 585.0 |
| 10911 | 17 | Alice Mutton | 39.0 | 12 | 0.0 | 468.0 |
| 10915 | 17 | Alice Mutton | 39.0 | 10 | 0.0 | 390.0 |
| 10922 | 17 | Alice Mutton | 39.0 | 15 | 0.0 | 585.0 |
| 10949 | 17 | Alice Mutton | 39.0 | 6 | 0.0 | 234.0 |
| 10972 | 17 | Alice Mutton | 39.0 | 6 | 0.0 | 234.0 |
| 11059 | 17 | Alice Mutton | 39.0 | 12 | 0.0 | 468.0 |
| 11064 | 17 | Alice Mutton | 39.0 | 77 | 0.1 | 2702.7 |
| 10289 | 3 | Aniseed Syrup | 8.0 | 30 | 0.0 | 240.0 |
| 10405 | 3 | Aniseed Syrup | 8.0 | 50 | 0.0 | 400.0 |
| 10485 | 3 | Aniseed Syrup | 8.0 | 20 | 0.1 | 144.0 |
| 10540 | 3 | Aniseed Syrup | 10.0 | 60 | 0.0 | 600.0 |
| 10591 | 3 | Aniseed Syrup | 10.0 | 14 | 0.0 | 140.0 |
| 10702 | 3 | Aniseed Syrup | 10.0 | 6 | 0.0 | 60.0 |
| 10742 | 3 | Aniseed Syrup | 10.0 | 20 | 0.0 | 200.0 |
| 10764 | 3 | Aniseed Syrup | 10.0 | 20 | 0.1 | 180.0 |
| 10849 | 3 | Aniseed Syrup | 10.0 | 49 | 0.0 | 490.0 |
| 10857 | 3 | Aniseed Syrup | 10.0 | 30 | 0.0 | 300.0 |
| 11017 | 3 | Aniseed Syrup | 10.0 | 25 | 0.0 | 250.0 |
| 11077 | 3 | Aniseed Syrup | 10.0 | 4 | 0.0 | 40.0 |
| 10267 | 40 | Boston Crab Meat | 14.7 | 50 | 0.0 | 735.0 |