postgres do not show duplicates code example

Example 1: postgres select duplicate columns

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

Example 2: psql select unique

SELECT
   DISTINCT column1
FROM
   table_name;