postgresql remove duplicate rows 2 columns

select Column1, Column2, count(*)
from yourTable
group by Column1, Column2
HAVING count(*) > 1

select * from yourTable ou
where (select count(*) from yourTable inr
where inr.sid = ou.sid) > 1

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