postgres select duplicate columns 1

postgres select duplicate columns

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

Here is what the above code is Doing:
1. Selecting the columns you want to check for duplicates
2. Grouping by the columns you want to check for duplicates
3. Having a count greater than 1 (i.e. more than 1 record)

Similar Posts