SqlServer 分组后按排序字段取最大的一条记录

select s.*
from (
select row_number() over (partition by [分组字段] order by [排序字段] desc) as order_num,v.*
from [表名] v
) s
where s.order_num = 1