Re: SQL help. Counting duplicate rows (Grrrr kill users!)

select col_1, count(*)
from table_name
having count(*) > 1
group by col_1
order by count(*) desc
/

This should get you the list you desire.

Hope this helps,

John Hough Received on Tue Nov 26 1996 - 00:00:00 CST