/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 vote337 views1 answer
Get employees if not contains in sql
SQL
10 votes354 views3 answers
Join multiple tables sql
SQL
0 vote327 views1 answer
Postgres truncate with cascade
SQL
0 vote339 views1 answer
Mysql select statement after index
SQL
5 votes316 views3 answers
Truncate function in sql oracle
SQL
0 vote345 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
1 vote359 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote368 views1 answer
Local pg_sql to heroku pg_sql
SQL
3 votes333 views1 answer
Sql multi column index performance
SQL
1 vote334 views2 answers
Restart identity cascade
SQL