/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

1 vote222 views1 answer
SQLSTATE[HY000] [2002]
SQL
2 votes242 views3 answers
Mysql pass command from command line
SQL
1 vote257 views2 answers
Oracle create synonym
SQL
0 vote261 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
1 vote244 views3 answers
What is union in sql
SQL
0 vote236 views1 answer
Get enginge db mysql
SQL
0 vote227 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
2 votes237 views1 answer
Mysql query unique column
SQL
0 vote242 views1 answer
Mysql 8 error on identified by
SQL
0 vote227 views1 answer
Sql row number in result set
SQL