finding multiple rows with HAVING

select cityname from cities groupby cityname having count(*) > 1