SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between NOT IN & NOT EXISTS

994122Jan 21 2014 — edited Jan 21 2014

Hi all,

Difference between NOT IN & NOT EXISTS , those are given same results..

SELECT empno,ename from emp e

WHERE not exists (SELECT mgr FROM Emp Mgr)

SELECT empno,ename from emp e

WHERE empno not in (SELECT mgr FROM Emp Mgr)

Thank You please explain me..

This post has been answered by RogerT on Jan 21 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2014

Added on Jan 21 2014

#9i

10 comments

1,105 views