sqlserver分组取top

select s.*  

from ( 

    select *, row_number() over (partition by [分组字段] order by [排序字段]) as 别名  

    from 表名称

) s

where s.别名 = 1

　　..

sqlserver分组取top

标签：server   top   number   分组   rom   order by   select   sel   from