/SQL/Postgresql remove duplicate rows 2 columns

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 );

Similar codes

14 votes176 views2 answers
Oracle export trigger ddl
SQL
0 vote163 views1 answer
Mysql read row
SQL
5 votes166 views5 answers
Sqlite install python
SQL
0 vote229 views1 answer
Check user sql password from command line
SQL
7 votes182 views3 answers
SQL create a new table
SQL
0 vote182 views2 answers
Faster mysql imports
SQL
-1 vote176 views1 answer
How to change the auto increment in existing table mysql
SQL
4 votes158 views1 answer
Add constraint fk
SQL
0 vote208 views1 answer
How to find unique element in sql
SQL
3 votes174 views1 answer
Oracle user privileges
SQL