Combine SQL Queries With UNION, INTERSECT, EXCEPT

Published: 14 January 2020
on channel: Becoming a Data Scientist

52,466

1.3k

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: • How to Load a Sample PostgreSQL Datab...

Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:

Watch video Combine SQL Queries With UNION, INTERSECT, EXCEPT online without registration, duration hours minute second in high quality. This video was added by user Becoming a Data Scientist 14 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 52,466 once and liked it 1.3 thousand people.

876