56,678
社区成员
发帖
与我相关
我的任务
分享
(SELECT * FROM `表名` WHERE 类型="甲" ORDER BY rand() limit 0,3)
union all
(SELECT * FROM `表名` WHERE 类型="乙" ORDER BY rand() limit 0,1);
select top 3 * from tracy where AZWZ='1330采面'
union all
select top 1* from tracy where AZWZ='223水仓'
/*
AZWZ PJZ ZDZ BCSJ
1330采面 0.33 0.34 2010-01-01 00:00:00.000
1330采面 0.33 0.34 2010-01-01 00:05:00.000
1330采面 0.33 0.34 2010-01-01 00:00:00.000
223水仓 0.33 0.34 2010-01-01 00:00:00.000
*/
感觉不用union all一条语句实现有难度