查询多于两笔的员工数据

--查询多于两笔的员工数据
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