我的組像這樣分成幾行：
Row Group
1 A
2 A
3 A
4 B
5 B
6 C
7 C
8 C
9 C
如何為任意 2 個隨機選擇的組選擇所有行？
uj5u.com熱心網友回復：
隨機排序，選取 2 組。
SELECT *
FROM your_table AS t
WHERE `Group` IN (
SELECT `Group` FROM (
SELECT `Group`
FROM your_table
GROUP BY `Group`
ORDER BY RAND()
LIMIT 2) q);
db<>在這里擺弄
uj5u.com熱心網友回復：
選擇任意兩個組的行
select *
from t_groups
group by Group
having Group in ['A', 'B'];
隨機選擇任意兩組
select *
from t_groups
group by Group
having Group in (
SELECT Group FROM t_groups
ORDER BY RAND()
LIMIT 2);
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/377394.html
上一篇：在MYSQL中向表中添加新資料