Delete duplicate rows in database table (postgresql).
Posted Over 11 years ago by mgns.
stackoverflow.com
DELETE FROM in_mam WHERE ctid NOT IN (SELECT MAX(ctid) FROM in_mam GROUP BY video_id, mam_id...
DELETE FROM in_mam WHERE ctid NOT IN (SELECT MAX(ctid) FROM in_mam GROUP BY video_id, mam_id...