请大家帮忙看一个SQL语句，关于Union 和Order by

[mingjunr]

select top 2 * from Customers where city='London' order by newid()
union
select top 3 * from Customers where city='Bern' order by newid()
看上面这个语句该怎么写？上面的写法是错误的
意图如下：
在顾客表里随机抽两个london的客人和3 个Bern的客人！！

[nboys]

select * from (select top 2 * from Customers where city='London' order by newid()) a

union all

select * from (select top 3 * from Customers where city='Bern' order by newid()) b

[erigido]

学习,确实很巧妙啊

[CrazyFor]

看不出上面的有什么问题啊,怎么错了?

[txlicenhe]

Select * from (select top 2 * from Customers where city='London' order by newid()) a
union
select * from (select top 3 * from Customers where city='Bern' order by newid()) b

[hjb111]

写出一下错误信息!

[pengdali]

select * from (select top 2 * from Customers where city='London' order by newid()) tem
union all
select * from (select top 3 * from Customers where city='Bern' order by newid()) tem2

[zjcxc]

select * from
(select top 2 *,newid() as temp_id from syscolumns where name<>'London' order by newid()) a
union
select * from
(select top 3 *,newid() as temp_id from syscolumns where name<>'Bern' order by newid()) b

[woyaofengle]

你到底是要随机 还是要头两个

[sdhdy]

select * from (select top 2 * from Customers where city='London' order by newid()) aa
union all
select * from (select top 3 * from Customers where city='Bern' order by newid()) bb

[happydreamer]

select coloumnlist (except newid) from (select top 2 *,newid() a from Customers where city='London' order by newid()) tem
union all
select coloumnlist (except newid) from (select top 3 *,newid() from Customers where city='Bern' order by newid()) tem2


otherwise your will get error message
如果语句中包含 UNION 运算符，那么 ORDER BY 子句中的项就必须出现在选择列表中

[sdhdy]

order by newid()和union无法连用
try:
select top 2 * into #temp from Customers where city='London' order by newid()
insert #temp select top 3 * from Customers where city='Bern' order by newid()
select * from #temp
drop table #temp

[zjcxc]

这个问题在我的方法里已经避免了.