Prevent duplicate rows in postgres

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 );

Source: grepper.com

Similar codes

0 vote337 views1 answer
The local psql command could not be located
SQL
0 vote374 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote369 views1 answer
Search In the Database using Text
SQL
0 vote343 views1 answer
Sqlalchemy case insensitive like
SQL
1 vote338 views3 answers
Postgresql connect to database
SQL
0 vote363 views2 answers
Mysql on update current_timestamp
SQL
0 vote346 views1 answer
Check duplicate values plsql
SQL
1 vote358 views2 answers
Mysql filter by date mount
SQL
0 vote349 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote337 views1 answer
Back up stored procedures mysql
SQL