Postgres query check duplicate data

PHOTO EMBED

Mon Jan 03 2022 02:32:45 GMT+0000 (UTC)

Saved by @arifin21 #sql #postgres #duplicate

select "field1", "field2", count(*)
from "tableName"
group by "field1", "field2"
HAVING count(*) > 1
content_copyCOPY

stackoverflow

https://stackoverflow.com/