首页 > 试题广场 >

对于Sales表(CustomerID, SaleDate,

[单选题]

对于Sales表(CustomerID, SaleDate, Amount)，要获取每个客户的最近一笔销售记录日期，应如何编写SQL？

SELECT CustomerID, MAX(SaleDate) FROM Sales GROUP BY CustomerID

SELECT CustomerID, SaleDate FROM Sales ORDER BY SaleDate DESC

SELECT CustomerID, MAX(SaleDate) FROM Sales WHERE CustomerID IS NOT NULL

SELECT CustomerID, SaleDate FROM Sales GROUP BY CustomerID HAVING MAX(SaleDate)

查看答案及解析

这道题你会答吗？花几分钟告诉大家答案吧！

提交观点

问题信息

SQL

难度：

0条回答 25收藏 16浏览

扫一扫，把题目装进口袋