此篇博客探讨了如何使用SQL子查询结合聚合函数（如SUM）来分析部门薪资总额。通过创建名为your_table的临时表，展示了不同部门（10, 20, 30）和职位的薪资数据，并进行了按部门分组的薪资总和计算。这有助于理解SQL在数据汇总分析中的应用。
Something like thiss..
with your_table(dept_no, job, salary) as (
select 10, 'clerk', 1000 from dual union all
select 10, 'clerk', 2000 from dual union all
select 10, 'salesman', 1000 from dual union all
select 10, 'president', 1000 from dual union all
select 10, 'manager', 1000 from dual union all
select 10, 'analyst', 1000 from dual union all
select 20, 'clerk', 1000 from dual union all
select 20, 'clerk', 1000 from dual union all
select 30, 'manager', 1000 from dual )
select * from (
select a.dept_no, a.job, a.salary,
(select sum(salary) from your_table where job=a.job) total
from your_table a )
pivot(
sum(salary) for dept_no in (10, 20, 30) )
Thanks and Regards,
Vysakh Suresh
扫一扫
648
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
