SqlServer 取表某一列相同ID最大时的数据 SELECT * FROM(SELECT *,ROW_NUMBER() OVER(PARTITION BY UserName ORDER BY Id DESC) Num FROM dbo.[User] ) t WHERE t.Num=1