1 查出列当中重复的值 select ip2,count(*) from vm_info group by ip2 having count(*)>1 期中ip2为列名 vm_info为表名 转载于:https://www.cnblogs.com/nodchen/p/10026388.html