求sqlserver2005查找语句的写法表的列:id,name,cost查找要求,按照name进行分组,对分组的结果按照cost的降序排列

Question

求sqlserver2005查找语句的写法 表的列:id,name,cost
查找要求,按照name进行分组,对分组的结果按照cost的降序排列

Answer 1

select id, name, cost
from (select id, name, cost, row_number() over(partition by name order by cost desc) rk from tab) t
order by name, rk