/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

15 votes484 views2 answers
Sql order by alphabetical
SQL
-1 vote331 views1 answer
Can pandas fetch data from sql
SQL
0 vote317 views1 answer
Check psql validity function
SQL
0 vote355 views1 answer
Python mysql show databases
SQL
0 vote334 views1 answer
Radius search with point data in mysql
SQL
0 vote336 views1 answer
Mariadb cast null to 0
SQL
7 votes346 views2 answers
Where keyword sql
SQL
-1 vote320 views3 answers
Create temp table in sql
SQL
0 vote323 views1 answer
Inner join distinct
SQL
-2 votes323 views1 answer
Use of where in left join in mysql
SQL