问题详情

你有如下名为Sales的表。你需要返回销售数据,并按客户名称和销售日期排序。对于每个客户,必须先列出最近的销售。应使用哪个查询?


A、SELECT

C、stomerName, SalesDate FROM Sales ORDER BY CustomerName, SalesDate;

B、SELECT

C、stomerName, SalesDate FROM Sales ORDER BY SalesDate DESC, CustomerName;

C、SELECT CustomerName, SalesDate FROM Sales ORDER BY CustomerName,

D、SELECT

C、stomerName, SalesDate FROM Sales ORDER BY CustomerName DESC;

时间:2021-09-01 16:21 关键词: 软件工程

答案解析

C
相关问题