感谢各位，问题应经解决，order by 和union可以在一起用
select * from(select top 5 * from table1 order by newid())A union
select * from (select top 5 * from table1 order by newid())B就可以了
select * from(select top 5 * from table1 order by newid())A union
select * from (select top 5 * from table1 order by newid())B就可以了
