利用SQL语句查询数据库中具体某个字段的重复行 select zyzlb,nation,frzw from jgdx where zyzlb in (select zyzlb from jgdx group by zyzlb having COUNT(*)>1) order by zyzlb