sql语句查询重复值

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