SQL server 分组 取值

SQL server 分组获取每组某值最大的一条数据

  select  from (
    select 
         row_number() over(partition by x order by y desc) as rid,
      from z
 ) as tt
  where tt.rid=1