注意：此页面搜索的是所有试题
题目内容
（软件工程）
你有如下名为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;
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;
参考答案