我想您可以将几个
SELECts与
UNIOns 组合在一起进行子查询。
SELECT a, b, c, dFROM ( SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS d UNIOn ALL SELECT 5 , 6, 7, 8) AS temp;
我想您可以将几个
SELECts与
UNIOns 组合在一起进行子查询。
SELECT a, b, c, dFROM ( SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS d UNIOn ALL SELECT 5 , 6, 7, 8) AS temp;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
