At 04:08 PM 4/11/2001 -0700, Ron Brogden wrote:
>SELECT column_name, count(*) AS doubles FROM some_table HAVING doubles > 1
>GROUP BY colname
Ack, that GROUP BY should be "column_name" (was trying to make it more
obvious and missed the last reference).
Cheers
-
At 03:38 PM 4/11/2001 -0700, SHAWN wrote:
>What's the SELECT statment I want to use to find duplicate entries in a
>specific field?
SELECT column_name, count(*) AS doubles FROM some_table HAVING doubles > 1
GROUP BY colname
This should grab all instances where there are multiple instances of
"
I can't find the answer to this, I know it's easy.
What's the SELECT statment I want to use to find duplicate entries in a
specific field?
Thanks in Advance!
Shawn Sellars
