随笔

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

获取name重复的记录