advanced code snippet search
geekzspot on 12/05/12
SQL to delete duplicate data or rows
(Here we use two columns: empno and ename)
DELETE empWHERE ROWID NOT IN (SELECT MIN(ROWID) FROM empGROUP BY empno,ename);
Report this snippet
You need to login to post a comment.