How to find duplicate entry ?

[windowsxp]

I have a table where cityName is a column.

I want to find if there are same cityName exists and if so how many count for each entry.

What is the query ?

[gk53]

that will give you all duplicates and number of them

select count(cityName) as num, cityName
from yourTable
having count(cityName)>1
group by cityName

[r937]

that will give you all duplicates and number of them

very close...

... but HAVING comes after GROUP BY