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.
