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