Saturday, February 21, 2015

Delete duplicate rows

Example:
DELETE FROM PRODUCT WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM PRODUCT GROUP BY ID);


No comments:

Post a Comment