17,082
社区成员
发帖
与我相关
我的任务
分享
select aa.salary,nvl(bb.salary_type,0) salary_type
from
(select 'A' salary from dual
union all
select 'B' salary from dual
union all
select 'c' salary from dual
union all
select 'd' salary from dual
) aa,
(select a.salary,sum(a.salary_type)) salary_type
from a
group by a.salary)
bb
where aa.salary=bb.salary(+)