Javatpoint Logo
Javatpoint Logo

Oracle Anti Join

Anti-join is used to make the queries run faster. It is a very powerful SQL construct Oracle offers for faster queries.

Anti-join between two tables returns rows from the first table where no matches are found in the second table. It is opposite of a semi-join. An anti-join returns one copy of each row in the first table for which no match is found.

Anti-joins are written using the NOT EXISTS or NOT IN constructs.


Let's take two tables "departments" and "customer"

Departments table

Oracle Anti Join

Customer table

Oracle Anti Join 2

Execute this query


Oracle Anti Join 3
Next TopicOracle Semi Join

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA