Home >> SQL >> Not Exits in SQL

Not Exits in SQL

The NOT EXITS is similar to NOT IN.

The NOT EXITS is faster than NOT IN.

The NOT EXITS used to check whether the result of a correlated nested query is empty or not.

The NOT EXITS will return TRUE if there is no result in the nested query.

Example

SELECT * FROM suppliers s WHERE NOT EXITS (SELECT o.name FROM orders o WHERE s.sid=o.sid);

Post Your Comment

Next Questions
Any
All
Max
Min
Avg
Count
Sum

Copyright ©2022 coderraj.com. All Rights Reserved.