3,492
社区成员
发帖
与我相关
我的任务
分享
with a as(
select 1 id,'a' name from dual
union all
select 2 id,'b' name from dual
union all
select 3 id,'c' name from dual
),b as(
select 1 id,'张三' name, 10 money from dual
union all
select 1 id,'李四' name, 12 money from dual
union all
select 3 id,'王五' name, 13 money from dual
)
select a.name,nvl(sum(money),0) from a,b where a.id = b.id(+) group by a.name
select a.name ,nvl(sum(b.money) over( order by b.classId),0)
from A a left join B b on a.classid=b.classid
where a.classId = 1
group by a.name