select * from user t where t.name in (select name from user group by name on having count(name) > 1)
user 表 ,然后查询name字段重复的记录
当然select * 不建议哈,这里是方便记录
onlyzhangmeng 2021-12-06 18:06 原文
select * from user t where t.name in (select name from user group by name on having count(name) > 1)
user 表 ,然后查询name字段重复的记录
当然select * 不建议哈,这里是方便记录