BookStore数据库中有销售明细表OrderDetail（OrderCode BookCode Amount) 查询销售总量前20%的
已帮助 人
BookStore数据库中有销售明细表OrderDetail（OrderCode, BookCode, Amount) 查询销售总量前20%的图书，并按总销量降序排列。SQL语句： SELECT TOP 20 PERCENT Bookcode As 书号, SUM（Amount)As总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________
A．Amount DESC
B．SUM(Amount) DESC
C．COUNT(Amount) DESC
D．ADD(Amount) DESC
回答
共1条回复-
INSERT INTO OrderDetail(OrderCode, Amount, BookCode) VALUES('08110801',3, '0701');INSERT INTO OrderDetail(OrderCode, BookCode, Amount) VALUES('08110801', '0701', 3);INSERT INTO OrderDetail VALUES('08110801', '0701', 3)