34,594
社区成员
发帖
与我相关
我的任务
分享
select E01.B01_DEPT_CODE as 所在部门,E01.E0107 as 计划人数,(select count(VIEW_A01.A0188) from VIEW_A01 where B01_DEPT_CODE=E01.B01_DEPT_CODE) as 在岗人数 from E01 left join View_a01 on
E01.B01_DEPT_CODE =view_a01.B01_DEPT_CODE group by E01.B01_DEPT_CODE,E0107
SELECT E01.B01_DEPT_CODE AS 所在部门 ,
E01.E0107 AS 计划人数 ,
( SELECT COUNT(VIEW_A01.A0188)
FROM VIEW_A01
WHERE B01_DEPT_CODE = E01.B01_DEPT_CODE
) AS 在岗人数 ,
( E01.E0107 - ( SELECT COUNT(VIEW_A01.A0188)
FROM VIEW_A01
WHERE B01_DEPT_CODE = E01.B01_DEPT_CODE
) ) AS 缺岗人数
FROM E01
LEFT JOIN View_a01 ON E01.B01_DEPT_CODE = view_a01.B01_DEPT_CODE
GROUP BY E01.B01_DEPT_CODE ,
E0107