Read-only Back to SQLite3 Guide
Northwind › Views
Orders Qry view

830 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.

Data Structure
Rows 1–25 of 830
OrderID CustomerID EmployeeID OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry CompanyName Address City Region PostalCode Country
10643 ALFKI 6 1997-08-25 1997-09-22 1997-09-02 1 29.46 Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany
10692 ALFKI 4 1997-10-03 1997-10-31 1997-10-13 2 61.02 Alfred's Futterkiste Obere Str. 57 Berlin NULL 12209 Germany Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany
10702 ALFKI 4 1997-10-13 1997-11-24 1997-10-21 1 23.94 Alfred's Futterkiste Obere Str. 57 Berlin NULL 12209 Germany Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany
10835 ALFKI 1 1998-01-15 1998-02-12 1998-01-21 3 69.53 Alfred's Futterkiste Obere Str. 57 Berlin NULL 12209 Germany Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany
10952 ALFKI 1 1998-03-16 1998-04-27 1998-03-24 1 40.42 Alfred's Futterkiste Obere Str. 57 Berlin NULL 12209 Germany Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany
11011 ALFKI 3 1998-04-09 1998-05-07 1998-04-13 1 1.21 Alfred's Futterkiste Obere Str. 57 Berlin NULL 12209 Germany Alfreds Futterkiste Obere Str. 57 Berlin NULL 12209 Germany
10308 ANATR 7 1996-09-18 1996-10-16 1996-09-24 3 1.61 Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico
10625 ANATR 3 1997-08-08 1997-09-05 1997-08-14 1 43.9 Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico
10759 ANATR 3 1997-11-28 1997-12-26 1997-12-12 3 11.99 Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico
10926 ANATR 4 1998-03-04 1998-04-01 1998-03-11 3 39.92 Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico Ana Trujillo Emparedados y helados Avda. de la Constitución 2222 México D.F. NULL 05021 Mexico
10365 ANTON 3 1996-11-27 1996-12-25 1996-12-02 2 22.0 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10507 ANTON 7 1997-04-15 1997-05-13 1997-04-22 1 47.45 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10535 ANTON 4 1997-05-13 1997-06-10 1997-05-21 1 15.64 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10573 ANTON 7 1997-06-19 1997-07-17 1997-06-20 3 84.84 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10677 ANTON 1 1997-09-22 1997-10-20 1997-09-26 3 4.03 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10682 ANTON 3 1997-09-25 1997-10-23 1997-10-01 2 36.13 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10856 ANTON 3 1998-01-28 1998-02-25 1998-02-10 2 58.43 Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico Antonio Moreno Taquería Mataderos 2312 México D.F. NULL 05023 Mexico
10355 AROUT 6 1996-11-15 1996-12-13 1996-11-20 1 41.95 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
10383 AROUT 8 1996-12-16 1997-01-13 1996-12-18 3 34.24 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
10453 AROUT 1 1997-02-21 1997-03-21 1997-02-26 2 25.36 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
10558 AROUT 1 1997-06-04 1997-07-02 1997-06-10 2 72.97 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
10707 AROUT 4 1997-10-16 1997-10-30 1997-10-23 3 21.74 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
10741 AROUT 4 1997-11-14 1997-11-28 1997-11-18 3 10.96 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
10743 AROUT 1 1997-11-17 1997-12-15 1997-11-21 2 23.72 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
10768 AROUT 3 1997-12-08 1998-01-05 1997-12-15 2 146.32 Around the Horn Brook Farm Stratford St. Mary Colchester Essex CO7 6JX UK Around the Horn 120 Hanover Sq. London NULL WA1 1DP UK
‹ Previous Page 1 of 34 Next › Query this view in the SQL console ›