/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 vote265 views1 answer
Postgres select as csv
SQL
0 vote195 views1 answer
Mysql streaming example
SQL
0 vote161 views1 answer
Postgres delete where id in
SQL
0 vote145 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
1 vote215 views1 answer
Postgres get month name from date
SQL
0 vote196 views4 answers
How to connect form to database
SQL
12 votes189 views2 answers
Delete entries in postgresql
SQL
3 votes281 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote222 views2 answers
Sql server select first day of previous year
SQL
0 vote196 views1 answer
Sql server select value large text
SQL