DELETE FROM TABLE_NAME
WHERE ROWID IN (SELECT RID
FROM (SELECT ROWID RID,
ROW_NUMBER() OVER (PARTITION BY
COLUMN_NAME1, COLUMN_NAME2…
DELETE FROM TABLE_NAME
WHERE ROWID IN (SELECT RID
FROM (SELECT ROWID RID,
ROW_NUMBER() OVER (PARTITION BY
COLUMN_NAME1, COLUMN_NAME2…Continue reading on Medium » Read More Sql on Medium
#sql