drop table product;
CREATE TABLE PRODUCT(
product_id varchar(6)
,product_name varchar(12)
,in_price integer
,out_price integer
,start_day timestamp
,primary key (product_id,start_day)
);
COMMENT ON TABLE product IS '商品';
COMMENT ON COLUMN product.product_id IS '商品コード';
COMMENT ON COLUMN product.product_name IS '商品名';
COMMENT ON COLUMN product.in_price IS '購入価格';
COMMENT ON COLUMN product.out_price IS '販売価格';
COMMENT ON COLUMN product.start_day IS '販売日' ;
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10001','小米手機','2100',3666,to_date('20190101','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10001','小米手機','2000',3666,to_date('20190201','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10001','小米手機','1988',3666,to_date('20190401','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10002','美的','6100',8666,to_date('20190301','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10002','美的','6300',8666,to_date('20190315','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10002','美的','5900',8666,to_date('20190401','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10003','洗衣機','1980',3666,to_date('20190423','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10003','洗衣機','1790',3666,to_date('20190503','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10003','洗衣機','2000',3666,to_date('20190623','yyyymmdd'));
如何用 select 的方式 寫出 商品代碼，商品名稱，購買數量，還有購買總價格。
請大神指導小弟一二。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/133741.html
標籤：應用實例
上一篇：求大神解答(為啥子這么多錯誤)
下一篇：求大神