SELECT *
FROM(SELECT *,ROW_NUMBER() OVER(PARTITION BY UserName ORDER BY Id DESC) Num FROM dbo.[User]
) t WHERE t.Num=1
转载于:https://www.cnblogs.com/sanday/p/9551653.html
SqlServer 取表某一列相同ID最大时的数据
SELECT *
FROM(SELECT *,ROW_NUMBER() OVER(PARTITION BY UserName ORDER BY Id DESC) Num FROM dbo.[User]
) t WHERE t.Num=1
转载于:https://www.cnblogs.com/sanday/p/9551653.html
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
