select top 3 * from tablename order by [count] desc
union all
select * from tablename
where id not in (select top 3 id from tablename order by [count] desc)
order by [Id] desc
union all
select * from tablename
where id not in (select top 3 id from tablename order by [count] desc)
order by [Id] desc
在Union 查询中,Sql server 提示 order by 只能应用于列表选项里select * from tablename order by [count] union .....后面就会提示union 附近有语法错误哪位大侠,知道如何解决啊?