單項選擇題
有名為?Sales?的表,現(xiàn)需要按客戶姓名(CustomerName)和銷售日期(SalesDate)排序返回銷售數(shù)據(jù)。為每個客戶提供最近期的銷售必須首先列出。應使用的查詢語句為()
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