/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 vote178 views1 answer
Copy table dbeaver
SQL
0 vote241 views1 answer
Insert data from stored procedure into table
SQL
0 vote232 views1 answer
Java mysql swing example
SQL
0 vote222 views1 answer
Order by ip address sql
SQL
2 votes263 views2 answers
Null column to 0 in mysql
SQL
2 votes238 views1 answer
Set auto increment from 1
SQL
1 vote240 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote213 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote218 views1 answer
SQL get max per id
SQL
1 vote219 views3 answers
Epoch to datetime
SQL