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