/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

0 vote358 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote384 views1 answer
Sql select without column name
SQL
49 votes426 views6 answers
Mysql add column to table
SQL
0 vote363 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
8 votes352 views2 answers
Grant all privileges database postgres to user
SQL
0 vote359 views1 answer
Compare two tables to find unmatched records
SQL
0 vote360 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote333 views1 answer
Mysql select where text contains
SQL
0 vote348 views2 answers
Mysql dump structure only
SQL
11 votes405 views2 answers
Import mysql dump command line windows
SQL