Application Express

Master Detail (Click department to edit)

Edit	Department	Employee Count	Percent of Organization
	Accounting	23
	Research and Development	22
	Sales	18
	Operations	11
	Customer Support	29

1 - 5

SQL

SELECT 
   d."DEPTNO" "DEPTNO", 
   d."DNAME" "DNAME", 
   d."LOC" "LOC",
   (select count(*) from wwv_demo_emp e where e.deptno = d.deptno) employee_count,
   round( (select count(*) from wwv_demo_emp e where e.deptno = d.deptno) /
      (select count(*) from wwv_demo_emp) * 100 )
      percent_of_organization
FROM 
   "WWV_DEMO_DEPT" d

About

Cancel