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);
Copyright ©2022 coderraj.com. All Rights Reserved.