Combine SQL Queries With UNION, INTERSECT, EXCEPT

Step-by-step tutorial shows you how to combine your SQL queries (columns) with UNION, INTERSECT, and EXCEPT!

Queries:
1) Get the combined unique values in 2 columns: SELECT column FROM table1 UNION SELECT column FROM table 2
2) Get the unique values that are present in 2 columns: SELECT column FROM table1 INTERSECT SELECT column FROM table 2
3) Get the values that aren't present in 2 columns: SELECT column FROM table 1 EXCEPT SELECT column FROM table 2

Get the Northwind Database: https://www.youtube.com/watch?v=nbIicI7K6Kk

Support the Channel:
1) Subscribe: https://www.becomingads.com/o/youtube
2) DataCamp: https://www.becomingads.com/o/datacamp
3) Udacity: https://www.becomingads.com/o/udacity

Видео Combine SQL Queries With UNION, INTERSECT, EXCEPT канала Becoming a Data Scientist