查询一个表中某字段重复记录 sql语句
select * from user t where t.name in (select name from user group by name on having count(name) > 1)
user 表 ，然后查询name字段重复的记录
select * from user t where t.name in (select name from user group by name on having count(name) > 1)
user 表 ，然后查询name字段重复的记录