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

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

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/gary-tao/p/5888665.html