Eliminating duplicates from subquery...
526844Jan 14 2008 — edited Jan 16 2008What is the best way to eliminate duplicates from a subquery:
SELECT dept_no, dept_name
FROM dept D
WHERE EXISTS (
SELECT 'X'
FROM emp E
WHERE E.dept_no = D.dept_no);
OR
SELECT dept_no, dept_name
FROM dept D
WHERE ( SELECT 'X'
FROM emp E
WHERE E.dept_no = D.dept_no AND ROWNUM < 2);
Thanks!