基本写法
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最大的行