利用SQL语句查询数据库中具体某个字段的重复行

select zyzlb,nation,frzw from jgdx where zyzlb in
(select zyzlb from jgdx group by zyzlb having COUNT(*)>1) order by zyzlb