/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 vote261 views1 answer
Sql select min
SQL
1 vote288 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
4 votes257 views2 answers
Error loading MySQLdb module.
SQL
0 vote316 views1 answer
Hierarchal database table
SQL
0 vote266 views1 answer
Alter table add foreign key mariadb example
SQL
3 votes272 views2 answers
Tsql join multiple record in one string
SQL
0 vote256 views1 answer
Mysql command line ubuntu
SQL
0 vote279 views1 answer
Sqlcl format
SQL
1 vote264 views1 answer
SQL date part only of datetime
SQL
13 votes276 views2 answers
Sql join 3 tables
SQL