Tuesday, October 21, 2008

Find Duplicate Rows

SQL> SELECT * FROM EMP WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM EMP GROUP BY SAL);

No comments: