Differenzen anzeigen

ID296
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangEXASOL
PlGroupDatenmengen
PlItemTitleDifferenzen anzeigen
CodeWITH a AS (
SELECT 1 AS n UNION ALL
SELECT 2 AS n UNION ALL
SELECT 3 AS n UNION ALL
SELECT 4 AS n
),
b AS (
SELECT 4 AS n UNION ALL
SELECT 5 AS n UNION ALL
SELECT 6 AS n UNION ALL
SELECT 7 AS n
)
SELECT * FROM a
EXCEPT -- <------------------------------
SELECT * FROM b
Result Example
N
1
2
3