/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 vote377 views1 answer
Postgres rename database
SQL
3 votes324 views1 answer
Oracle apex warn on unsaved changes
SQL
2 votes374 views3 answers
Xampp mysql database not starting
SQL
0 vote335 views4 answers
How to connect form to database
SQL
4 votes322 views1 answer
What are the data types in sql
SQL
0 vote323 views1 answer
Sql search all columns of database oracle sql
SQL
2 votes340 views1 answer
Codeigniter print last sql query
SQL
37 votes333 views3 answers
Postgresql insert column
SQL
0 vote380 views1 answer
Sql cursor example multiple columns
SQL
0 vote326 views1 answer
How to combine rows in sql server procedure
SQL