#MySQL #tutorial #course
Union tutorial example explained
-- NO DUPLICATES
SELECT first_name, last_name FROM employees
UNION
SELECT first_name, last_name FROM customers;
-- DUPLICATES OK
SELECT first_name, last_name FROM employees
UNION ALL
SELECT first_name, last_name FROM customers;
Union tutorial example explained
-- NO DUPLICATES
SELECT first_name, last_name FROM employees
UNION
SELECT first_name, last_name FROM customers;
-- DUPLICATES OK
SELECT first_name, last_name FROM employees
UNION ALL
SELECT first_name, last_name FROM customers;
- Category
- Bro Code
- Tags
- MySQL tutorial for beginners, SQL tutorial for beginners, MySQL course

Be the first to comment