Hello All,
I would like to replace IN with EXISTS in this example. Could you please help me achieving it.
SELECT * FROM emp WHERE empno IN (SELECT empno FROM emp)
I want to replace 'In' here with 'Exists'.
SELECT * FROM emp WHERE exists(SELECT 1 FROM emp ...?
Thx
Shank.