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

20 votes95 views4 answers
Sqlite create table if not exists
SQL
0 vote101 views2 answers
Mysql multiply
SQL
0 vote93 views1 answer
Concatenate columns in table
SQL
11 votes124 views2 answers
Sql between date range
SQL
1 vote96 views1 answer
Float precision in psql
SQL
0 vote109 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote98 views1 answer
To change the database owner in SQL server
SQL
0 vote97 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote89 views1 answer
Sql server 2012 create or alter procedure
SQL
3 votes86 views1 answer
Set default today mysql
SQL