2,497
社区成员
发帖
与我相关
我的任务
分享
//这样也行,只要你能理解相关子查询,方法有很多
SELECT *
FROM T1 A
WHERE ID IN (SELECT TOP 1 ID FROM T1 WHERE NAME=A.NAME ORDER BY DATE DESC)
SELECT *
FROM TABLE A
WHERE NOT EXISTS (SELECT 1 FROM TABLE WHERE NAME=A.NAME AND Date>A.DATE)
SELECT NAME,MAX(DATE) FROM TABLE_NAME GROUP BY NAME