Re: [HACKERS] Should the following work...? - Mailing list pgsql-hackers

The Hermit Hacker wrote:
> To find duplicate records, or, at least,
> data in a particular field, he suggests 
> just doing:
> 
>    SELECT id,count(1)
>      FROM clients
>  GROUP BY id
>    HAVING count(1) > 1;
> 
> A nice, clean, simple solution :)

Ya.  That's pretty.  For some
reason I always forget using the
'HAVING' clause, and end up using
a double where clause.  

:) Clark