27,580
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM #Tmp_A
WHERE ID In (
SELECT MAX(ID)AS ID FROM #Tmp_A A
LEFT OUTER JOIN (
SELECT [NAME],MAX(score) AS score
FROM #Tmp_A
GROUP BY [name]) B
ON A.[NAME] = B.[NAME]
WHERE A.score = B.score
GROUP BY A.[NAME])
id name score
----------- ---------- -----------
3 b 40
4 a 60
(2 行受影响)