Here is the query for the same.
DELETE FROM
table_name A
WHERE
a.rowid >
(
SELECT
min(B.rowid)
FROM
table_name B
WHERE
A.col1 = B.col1
AND
A.col2 = B.col2
);
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment