select top 20 * from (select top 140 * from PaperQuestion order by QuesID) as PaperSangle1 union select top 20 * from (select top 50 * from PaperQuestion order by QuesID) as PaperSangle2 order by PaperSangle1.QuesID desc 只能有一个order by 并且排序列必须在第一个select中出现。
我搞了一半天,试了一种方法可行,贴出来大家看看: select top 20 * from (select top 20 * from (select top 140 * from PaperQuestion order by QuesID) as PaperSangle order by QuesID desc) as aa union select top 20 * from(select top 20 * from (select top 50 * from PaperQuestion order by QuesID) as PaperSangle order by QuesID desc) as bb 还是谢谢各位了
union
select top 20 * from (select top 50 * from PaperQuestion order by QuesID) as PaperSangle2 order by PaperSangle1.QuesID desc
只能有一个order by 并且排序列必须在第一个select中出现。
select top 20 * from (select top 20 * from (select top 140 * from PaperQuestion order by QuesID) as PaperSangle order by QuesID desc) as aa
union
select top 20 * from(select top 20 * from (select top 50 * from PaperQuestion order by QuesID) as PaperSangle order by QuesID desc) as bb
还是谢谢各位了