Tuesday, June 30, 2009

Eliminate duplicate rows from table

Eliminate duplicate rows from table

Delete from EMP a Where a.rowid <> (select min (b.rowid) from emp b where a.empno = b.empno); OR Delete from EMP a Where a.rowid <> (select max (b.rowid) from emp b where a.empno = b.empno);

0 comments:

Post a Comment