duplicate records in postgresql code example

Example 1: postgres select duplicate columns

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

Example 2: postgres select duplicate columns

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

Example 3: query to remove duplicate records in postgresql server

DELETE FROM
    basket a
        USING basket b
WHERE
    a.id < b.id
    AND a.fruit = b.fruit;