select * from employees where hiredate in (select hiredate from employees group by hiredate having count(*)>1)
order by hiredate
将表中重复的字段记录都找出来
最新推荐文章于 2022-08-02 02:42:21 发布
select * from employees where hiredate in (select hiredate from employees group by hiredate having count(*)>1)
order by hiredate