BookStore 数据库中有销售明细表 OrderDetail(OrderCode, BookCode, Amount) 查询销售总量前 20% 的图书,并按总销量降序排列。 SQL 语句: SELECT TOP 20 PERCENT Bookcode As 书号 , SUM(Amount)As 总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________
A.
SUM(Amount) DESC
B.
COUNT(Amount) DESC
C.
ADD(Amount) DESC
D.
Amount DESC
拍照语音搜题,微信中搜索"皮皮学"使用
参考答案:
参考解析:
知识点:
皮皮学刷刷变学霸
举一反三
【单选题】听力原文:W: It's good to see you again. What are you doing these days? You are still working at the same place, aren't you? M: Yes, I am. And I'm counting the days until retirement. Q: What can we learn a...
【简答题】改错题。 1. What are these? These are apples. 2. Mum, they are my friends, Jim and Mary. 3. — Your picture is very good. — No, it's not good. 4. They are woman teachers. 5. Are they your uncle?