postgresql SELECT query no duplicates code example
Example 1: postgres select duplicate columns
select Column1, Column2, count(*)
from yourTable
group by Column1, Column2
HAVING count(*) > 1
Example 2: 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;