How to find duplicate values with PostgreSQL

Lucio Flores
2020-06-24T00:38:05Z

query.sql

| select * from table t1
| where (select count(*) from table t2
| where t1.field = t2.field) > 1
| order by field