oracle的hr工资待遇,oracle的hr用户里employees表

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

写出来了。。。

select last_name,department_id ,case department_id

when 10 then (select count(*) from employees where department_id=10)

when 20 then (select count(*) from employees where department_id=20)

when 30 then (select count(*) from employees where department_id=30)

when 40 then (select count(*) from employees where department_id=40)

when 50 then (select count(*) from employees where department_id=50)

when 60 then (select count(*) from employees where department_id=60)

when 70 then (select count(*) from employees where department_id=70)

when 80 then (select count(*) from employees where department_id=80)

when 90 then (select count(*) from employees where department_id=90)

when 100 then (select count(*) from employees where department_id=100)

when 110 then (select count(*) from employees where department_id=110)

else null end "count"

from employees

group by last_name,department_id