sql语句查询重复值

select * from user where name in (select name from user group by name having count(*)>1)

posted @ 2013-09-12 17:15  visionwang  阅读(274)  评论(0)  编辑  收藏  举报