22,209
社区成员
发帖
与我相关
我的任务
分享
潇洒老乌龟,我服
select top 10 * from
(
select top 10 id,hits from table1 order by hits desc
union all
select top 10 id,hits from table2 order by hits desc
) tb
order by hits desc
select top 10 * from
(
select * from table1
union all
select * from table2
) t
order by hits desc