Write a SQL query to find records in Table A that are not in Table B without using NOT IN operator.

Write a SQL query to find records in Table A that are not in Table B without using NOT IN operator.

# option 1 . using joins

#option 2 . NOT EXISTS

If you want to be better in Analytics, then do follow the below Playlist:-

You can follow us on the below social media handles:-

[vdeepak]

we can use MINUS (set operator)
select * from table_A
MINUS select * from table_B

[ummehabiba]

very effective for interview
can you make hacker rank SQL queries solution
Because hacker rank SQl medium and Advance queries are more difficult.

[sandeepmanjunath]

can we use except set operator here seems simpler ?