What is Antijoins in SQL?

Data Science, AI and ML
,
#1

An anti join is when you want results from one table conditonal to some data not present in another table

Example: In a school, if you have a table comprising of all students, and another one comprising of all children of alumni, you would use an anti join to determine students who are not children of alumni

Usually implemented using a NOT IN or NOT EXISTS