有名为 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
正确答案:D
答案解析:有
微信扫一扫手机做题