本文提供了一种使用SQL查询的方法来找出公司中重复入职的员工记录。通过内嵌的子查询，可以筛选出那些拥有相同入职日期且出现次数超过一次的员工。
select * from employees where hiredate in (select hiredate from employees group by hiredate having count(*)>1)
order by hiredate
将表中重复的字段记录都找出来
select * from employees where hiredate in (select hiredate from employees group by hiredate having count(*)>1)
order by hiredate
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
