select zyzlb,nation,frzw from jgdx where zyzlb in (select zyzlb from jgdx group by zyzlb having COUNT(*)>1) order by zyzlb
利用SQL语句查询数据库中具体某个字段的重复行
原文：http://www.cnblogs.com/njccqx/p/5765722.html
