当前位置:百科知识 > 工学问答D

问题描述:

[单选] 有名为 Sales 的表,现需要按客户姓名(CustomerName)和销售日期(SalesDate)排序返回销售数据。为每个客户提供最近期的销售必须首先列出。应使用的查询语句为()
A.select CustomerName,SalesDate from Sales group by CustomerName,SalesDate B.select CustomerName,SalesDate from Sales order by CustomerName,SalesDate C.select CustomerName,SalesDate from Sales group by CustomerNameorderbySalesDateDESC D.select CustomerName,SalesDate from Sales order by CustomerName,SalesDateDESC
参考答案:查看
答案解析:
☆收藏

随机题目