How to Get Count of Repeated Values From a Table In SQL SERVER

Solution:

SELECT CityName, COUNT(*) CityName
FROM Cities
GROUP BY CityName
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC