1、查询重复 select id，name from users where id in (select id from users group by id having count(id)>=2)
2、去除重复 select distinct * from users
随手记事,布布扣,bubuko.com
随手记事
原文：http://www.cnblogs.com/xtt321/p/3599574.html
