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

1 vote184 views1 answer
Oracle sql average
SQL
1 vote184 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote225 views1 answer
Cahnge column name apex oracle
SQL
1 vote167 views1 answer
Deleting database in sql
SQL
0 vote184 views1 answer
Hoq to import database source
SQL
0 vote131 views1 answer
Mysql convert column to uppercase
SQL
1 vote166 views1 answer
Sql Split string function
SQL
0 vote156 views1 answer
Sql table to store status
SQL
-1 vote123 views2 answers
Datetime sql server week
SQL
0 vote208 views1 answer
Hashpass
SQL