sqlserver 取分组内最大值

基本写法

select * from B where b.c = (select max(c) from B where b='1') and b='1'

上升写法

select s.*
from (
    select v.*, row_number() over (partition by b order by c desc) as order_num
    from #b v where v.b='1'
) s
where s.order_num = 1

按照B分组，并且按照C排序，取C最大的行