当前位置: 首页 >  江开  > 软件工程  > 详细

你有如下名为Sales的表。你需要返回销售数据,并按客户名称和销售日期排序。对于每个客户,必须先列出最近的销售。应使用哪个查询?
A.SELECT
CustomerName, SalesDate FROM Sales ORDER BY CustomerName, SalesDate;
B.SELECT
CustomerName, SalesDate FROM Sales ORDER BY SalesDate DESC, CustomerName;
C.SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName,
SalesDate DESC;
D.SELECT
CustomerName, SalesDate FROM Sales ORDER BY CustomerName DESC;

答案是:

C
出自  江开  >  软件工程

更多答案联系客服:19139051760
本题添加时间:2023/4/3 12:59:00