item.sql

来自「BigC++的源码」· SQL 代码 · 共 9 行

CREATE TABLE Item (Invoice_Number INTEGER, Product_Code CHAR(10), Quantity INTEGER)
INSERT INTO Item VALUES (11731, '116-064', 3)
INSERT INTO Item VALUES (11731, '257-535', 1)
INSERT INTO Item VALUES (11731, '643-119', 2)
INSERT INTO Item VALUES (11732, '116-064', 10)
INSERT INTO Item VALUES (11733, '116-064', 2)
INSERT INTO Item VALUES (11733, '643-119', 1)
SELECT * FROM Item