Question

How to combines the result of two or more SELECT statements in SQL

Answer 1

--  SELECT with DISTINCT by default

SELECT FirstName FROM Workers
UNION
SELECT Meal FROM LunchOrders

 

70+ SQL courses for beginners and professionals

Answer 2

SELECT FirstName FROM Workers
UNION
SELECT Meal FROM LunchOrders
ORDER BY Meal

 

70+ SQL courses for beginners and professionals

Answer 3

--  (UNION ALL) SELECT without DISTINCT, allow duplicate 

SELECT FirstName FROM Workers
UNION ALL
SELECT Meal FROM LunchOrders

 

70+ SQL courses for beginners and professionals

Answer 4

SELECT category FROM all_info
UNION
SELECT word FROM words
WHERE word LIKE '%a%'

 

70+ SQL courses for beginners and professionals

Answer 5

SELECT category FROM all_info
UNION
SELECT word FROM words
WHERE word LIKE '%ie%'
Order BY category

 

70+ SQL courses for beginners and professionals