MSSQL 分组后取每组第一条(group by order by)

时间:2017-08-29 11:41:03   收藏:0   阅读:497

MSSQL 分组后取每组第一条(group by order by)

 

select * from ( select ROW_NUMBER() over(partition by x order by y desc) RowNum ,testTable.* from testTable) as t1 where RowNum = 1

记录一下,以后会用到

原文:http://www.cnblogs.com/li5206610/p/7447338.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!