SQL Tested
Delete duplicate rows but keep the newest
Remove duplicates in PostgreSQL using ROW_NUMBER over a partition, keeping one row per key.
Loading snippets…
13 snippets
Remove duplicates in PostgreSQL using ROW_NUMBER over a partition, keeping one row per key.