SQL--查询相同字段的数据

select city, state
from state_county_city
where city in (select city from state_county_city group by city having count(1) >= 2)