34,838
社区成员




select b.* from tb as a
cross apply
(select top 10 * from tb where mid=a.mid and mid in(100,200,204,114) order by 排序列) as b
select top(10) * from test
where mid = 100
union all
select top(10) * from test
where mid = 200
union all
select top(10) * from test
where mid = 114
union all
select top(10) * from test
where mid = 204