sql简单问题~~(50分)

Q

qrsgroup

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-02

• #1

请教，这样的SQL语句怎么些？<br>select top 2 * from info where sex='男' &nbsp;order by rnd(cid)<br>union<br>select top 3 * from info where sex='女' &nbsp;order by rnd(cid)<br><br>order by rnd(cid)随机查询<br>使用联合查询的时候不允许出现2个Order By ...<br><br>该如何随机抽取出2个男的，3个女的？？？

 

G

guxiaoke

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-02

• #2

SELECT * FROM (select top 2 * from info where sex='男' &nbsp;order by rnd(cid))<br>union<br>SELECT * FROM (select top 3 * from info where sex='女' &nbsp;order by rnd(cid))

 

L

lcm40

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-02

• #3

select * from<br>(<br>select top 2 * from info where sex='男' &nbsp;order by rnd(cid)<br>union<br>select top 3 * from info where sex='女' &nbsp;order by rnd(cid)<br>)a<br>order by rnd(a.cid)随机查询

 

Q

qrsgroup

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-04-02

• #4

结贴