advanced code snippet search

Posted By

geekzspot on 12/05/12


Tagged


Versions (?)

Oracle Delete Duplicates

 / Published in: SQL
 

SQL to delete duplicate data or rows (Here we use two columns: empno and ename)

Expand | Embed | Plain Text 
  1. DELETE emp
  2. WHERE ROWID NOT IN 
  3. (
  4. SELECT MIN(ROWID) FROM emp
  5. GROUP BY empno,ename
  6. );

Report this snippet  

You need to login to post a comment.