分享mysql查询字段重复的语句
程序员文章站
2022-05-20 18:44:53
分享mysql查询字段重复的语句
所有名字重复人的记录是:
select * from emp
where name in (select name from emp group by name...
分享mysql查询字段重复的语句
所有名字重复人的记录是:
select * from emp
where name in (select name from emp group by name having count(*)>1)