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
记录一下,以后会用到
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
记录一下,以后会用到
转载于:https://www.cnblogs.com/li5206610/p/7447338.html