方法1:select id,name from person where name in (select DISTINCT  name from person group by name  having count(*)>1 )

方法2:select name from person group by name having count(name)>1

posted on 2012-09-07 20:17  tnspop  阅读(262)  评论(0编辑  收藏  举报