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 vote198 views1 answer
Sql server count all tables rows
SQL
1 vote183 views1 answer
Encrypt password postgresql
SQL
2 votes205 views1 answer
Show max_allowed_packet mysql
SQL
0 vote191 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote202 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote190 views1 answer
Mysql add comment to column
SQL
0 vote196 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote196 views1 answer
Mysql docker image for macbook m1
SQL
0 vote149 views1 answer
Import csv to mysql
SQL
2 votes196 views3 answers
Write sql query to find the second highest salary of employee
SQL