17,377
社区成员
发帖
与我相关
我的任务
分享
select A.dept_name, B.C, C.C
from dept A
left join (select emp_dept,count(1) C from emp where to_char(emp_enterdate,'yyyy-mm') <='2011-10') and to_char(emp_joindate,'yyyy-mm') <='2011-10') group emp_dept) B
on a.dept_id = b.emp_dept
left join (select el_dept,count(1) C from el where To_char(el_date, 'yyyy-mm') = '2011-10' group by el_dept) C
on a.dept_id = c.el_dept
left join (select dr_dept_a,count(1) from dr where To_char(dr_date, 'yyyy-mm') = '2011-10' group by dr_dept_a) D
on a.dept_id = d.dr_dept_a
left join (select dr_dept_f,count(1) from dr where To_char(drt.dr_date, 'yyyy-mm') = '2011-10' group by dr_dept_f) E
on a.dept_id = e.dr_dept_f
直接给出源数据和结果数据!直接写SQL
select A.dept_name, B.C, C.C
from dept A
left join (select emp_dept,count(1) C from emp group emp_dept) B
on a.dept_id = b.emp_dept
left join (select el_dept,count(1) C from el group by el_dept) C
on a.dept_id = c.el_dept
left join (select dr_dept_a,count(1) from dr group by dr_dept_a) D
on a.dept_id = d.dr_dept_a
left join (select dr_dept_f,count(1) from dr group by dr_dept_f) E
on a.dept_id = e.dr_dept_f