查询一个表中某字段重复记录 sql语句

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

user 表 ，然后查询name字段重复的记录

当然select * 不建议哈，这里是方便记录