salesdetails Table

In this table, you'll find the line-item entries for each sales order. The order numbers are integers, as are qty_ordered and qty_shipped. The title identification number is fixed-length character. There is a unique composite index on the combination of sonum and title_id, and there are 21 rows.

						sonum title_id qty_ordered qty_shipped date_shipped
   not null not null not null    null        null
         sdind =========== ======== =========== =========== ==================== 1 PS2091 75 75 Sep 15 1998 12:00 am 2 PS2091 10 10 Sep 15 1998 12:00 am 3 PS2091 20 720 Sep 18 1998 12:00 am 4 MC3021 25 20 Sep 18 1998 12:00 am 5 MC3021 15 15 Sep 14 1998 12:00 am 6 BU1032 10 3 Sep 22 1998 12:00 am 7 PS2091 3 3 Sep 20 1998 12:00 am 8 BU1032 5 5 Sep 14 1998 ...

Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial