求解一问题

[wanghao2979]

select top 2 ID from 单选 order by newid()


这是一条sql语句,从一个表中选出2条随机记录


它只返回一列记录


select top 2 ID from 单选 order by newid()
select top 3 ID from 多选 order by newid()

我想把两条语句合起来..然后返回两列记录


要求:
1.求一存储过程

2.用临时表如何解决

[jin225]

select * from(select top 2 ID from 单选 order by newid()) as a UNION ALL
select * from (select top 3 ID from 多选 order by newid() ) as b

[mengxj85]

[Quote=引用 3 楼 jiang_jiajia10 的回复:]
SQL code
select top 2 ID as A,'' as B from 单选 order by newid()
union all
select top 3 '' as A,ID as B from 多选 order by newid()
[/Quote]
Mark

[HDNGO]

个数都不一样哇~

[wanghao2979]

select * from(select top 2 ID from 单选 order by newid()) as a UNION ALL
select * from (select top 3 ID from 多选 order by newid() ) as b


解决了!

[jiang_jiajia10]

select top 2 ID as A,'' as B from 单选 order by newid() 
union all
select top 3 '' as A,ID as B from 多选 order by newid()