SQL速记
时间:2022-03-13 22:51
- 集合操作
?
?
?
WITH a AS ( SELECT 1 id
UNION
SELECT 2
),
b AS ( SELECT 1 id
UNION
SELECT 3
)
SELECT *
FROM a
EXCEPT
SELECT *
FROM b;
?
WITH a AS ( SELECT 1 id
UNION
SELECT 2
),
b AS ( SELECT 1 id
UNION
SELECT 3
)
SELECT *
FROM a
INTERSECT
SELECT *
FROM b
?
?
SQL速记,布布扣,bubuko.com