Tuesday, April 3, 2007

Oracle delete duplicates

DELETE FROM our_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY column1, column2, column3...) ;

0 Comments:

Post a Comment

<< Home