Answers for "How to avoid duplicate records in PostgreSQL"

SQL
6

query postgres delete duplicates

DELETE FROM dups a USING (
      SELECT MIN(ctid) as ctid, key
        FROM dups 
        GROUP BY key HAVING COUNT(*) > 1
      ) b
      WHERE a.key = b.key 
      AND a.ctid <> b.ctid
Posted by: Guest on February-20-2020
0

postgresql remove duplicate rows 2 columns

DELETE FROM sf_table
WHERE id IN
    (SELECT id
    FROM 
        (SELECT id,
         ROW_NUMBER() OVER( PARTITION BY tosp, icd
        ORDER BY  id ) AS row_num
        FROM sf_table ) t
        WHERE t.row_num > 1 );
Posted by: Guest on June-10-2020

Code answers related to "How to avoid duplicate records in PostgreSQL"

Code answers related to "SQL"

Browse Popular Code Answers by Language