单项选择题
有名为?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