select *
from tb as t1
where id in(
select top 2 id
from tb as t2
where t1.bid=t2.bid
order by id desc)
order by bid, id desc
from tb as t1
where id in(
select top 2 id
from tb as t2
where t1.bid=t2.bid
order by id desc)
order by bid, id desc