--查询多于两笔的员工数据
select * from ehr.dbo.HR_UserInfo
where EmployeeID in (select EmployeeID from ehr.dbo.HR_UserInfo group by EmployeeID having count(EmployeeID) > 1)
and isQuit =''
order by EmployeeID
查询多于两笔的员工数据
最新推荐文章于 2023-05-16 09:23:13 发布