Примеры команд SQL в рамках урока #21

-- Работа с множествами в SQL (UNION, MINUS, INTERSECT)
-- https://www.youtube.com/watch?v=1n9oQE9i85c

-------------------------------------------
-- Примеры команд SQL в рамках урока #21


SELECT * FROM DEPARTMENTS_NEW;
SELECT * FROM DEPARTMENTS_OLD;


SELECT * FROM DEPARTMENTS_NEW
UNION ALL
SELECT * FROM DEPARTMENTS_OLD
;


SELECT * FROM DEPARTMENTS_NEW
UNION
SELECT * FROM DEPARTMENTS_OLD
;


SELECT * FROM DEPARTMENTS_NEW
MINUS
SELECT * FROM DEPARTMENTS_OLD
;


SELECT * FROM DEPARTMENTS_NEW
INTERSECT
SELECT * FROM DEPARTMENTS_OLD
;