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 vote240 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote249 views1 answer
Offset in postgresql example
SQL
4 votes180 views1 answer
And or sql order of operations
SQL
13 votes241 views2 answers
Sql online compiler
SQL
0 vote243 views1 answer
Mysql exception output
SQL
17 votes238 views4 answers
Mysql remove ubuntu
SQL
0 vote230 views1 answer
Write sql query to show the details start from digit
SQL
3 votes234 views2 answers
Mysql create database
SQL
-1 vote220 views1 answer
Module operator in oracle sql
SQL
11 votes229 views1 answer
Sql insert multiple rows from select
SQL