mysql + postgres - delete duplicate row

delete duplicate row.sql

-- delete duplicate rss - postgresql
DELETE FROM rss T1
    USING   rss T2
WHERE T1.ctid < T2.ctid
  AND T1.rss_source_id  = T2.rss_source_id
  AND T1.title  = T2.title
  AND T1.link  = T2.link;

  
-- delete duplicate rss - mysql
DELETE T1 FROM rss T1
    INNER JOIN rss T2
WHERE T1.rss_id < T2.rss_id
  AND T1.rss_source_id  = T2.rss_source_id
  AND T1.title  = T2.title
  AND T1.link  = T2.link;

-- delete duplicate rss - sqlite3
DELETE FROM rss WHERE rowid NOT IN (
    SELECT min(rowid) FROM rss GROUP BY rss_source_id, title, link
);