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);