随笔

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

获取name重复的记录

 

posted @ 2015-09-25 16:52  zzyoucan  阅读(128)  评论(0编辑  收藏  举报