sql查询某个字段重复的数据

select * from N041_湖北省 where bah in (select bah from N041_湖北省 group by bah having count(*)>1)