NOT IN & NOT EXISTS Antijoins - SQL in 60 seconds #shorts

Use NOT IN & NOT EXISTS to find all the rows from a table with no matching values in a subquery. Aka Antijoins.

Need help with SQL?

Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html

Ask us over on AskTOM: https://asktom.oracle.com

Twitter: https://twitter.com/ChrisRSaxon
Daily SQL Twitter tips: https://twitter.com/SQLDaily
All Things SQL blog: https://blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/

===========================
The Magic of SQL with Chris Saxon

Видео NOT IN & NOT EXISTS Antijoins - SQL in 60 seconds #shorts канала The Magic of SQL