Yep... that did the trick! (I forgot all 'bout that silly GROUP BY HAVING clause)
Thanks Dr. R
----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Saturday, December 18, 2004 10:00 AM
Subject: [RBG7-L] - Re: Duplicate row identification
At 06:18 AM 12/18/2004 -0800, Rob Vincent wrote:
R:Greetings,
I seem to recall an SQL syntax that would allow me to identify duplicate rows within a column of a single table.
Rob,
Here is one of many ways to find duplicate rows based on a single column value:
SELECT colname COUNT(*) FROM tablename GROUP BY colname HAVING COUNT(colname) > 1
That command will provide you with a list of values along with count having more
than one row.
Hope that helps!
Razzak.
