select * from TB_BUSINESSLICENSE where c_id in(select c_id from TB_BUSINESSLICENSE group by c_id having COUNT(c_id) >1) -- TB_BUSINESSLICENSE 为表名
本文出自 “猴子也疯狂” 博客，谢绝转载！
sql查询某个字段重复出现两次以上
原文：http://1251769215.blog.51cto.com/11633863/1784464
