The EXITS is similar to IN.
The EXITS is faster than IN.
The EXITS used to check whether the result of a correlated nested query is empty or not.
The EXITS will return TRUE if at least one tuple is the result of nested query.
SELECT * FROM suppliers s WHERE EXITS (SELECT o.name FROM orders o WHERE s.sid=o.sid);
Coderraj is the global online platform and circle for programmers to learn, communicate, share their knowledge and growth their careers.
Copyright ©2022 coderraj.com. All Rights Reserved.