去除重复数据的SQL语句

使用 MAX + group by：

SELECT BookId,MAX(CreateDate) AS MaxCreateDate FROM Table1
WHERE StationID=2
GROUP BY BookId
ORDER BY MaxCreateDate DESC

MAX在这里主要是用于排序。过滤重复的话，group by足矣\