DELETE FROM in_mam WHERE ctid NOT IN (SELECT MAX(ctid) FROM in_mam GROUP BY video_id, mam_id...

Best results in other decks

For some reason you have to pass the password hash if you want to create a role in postgres. To...

Delete duplicate rows in database table (postgresql).