Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 );
Source by www.postgresqltutorial.com #
 
PREVIOUS NEXT
Tagged: #postgresql #remove #duplicate #rows #columns
ADD COMMENT
Topic
Name
3+5 =