Prevent duplicate rows in postgres

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: grepper.com

Similar codes

0 vote254 views1 answer
Oracle last connection
SQL
0 vote288 views1 answer
Faire une recherche par liste de mot clé sql
SQL
1 vote252 views2 answers
Mysql spring boot application.properties
SQL
0 vote267 views1 answer
Sql select rows with different values in one column
SQL
45 votes337 views5 answers
Grant all privileges mysql
SQL
0 vote271 views1 answer
Mysql min value row
SQL
10 votes281 views2 answers
SQL rounding numbers
SQL
0 vote272 views1 answer
Order by in codeigniter query builder
SQL
0 vote263 views1 answer
Pl sql search in all packages
SQL
2 votes258 views2 answers
Install sqlalchemy
SQL