请教一个语句

[m0_38109279]

商品 销售数量
a 1
b 3
c 4
d 2

希望得到的结果是最后增加一列,是所有商品销量的合计,尽量不要关联子查询

商品 销售数量 合计
a 1 10
b 3 10
c 4 10
d 2 10

[jdsnhan]

with a  as 
(select 'a' col1,1 col2 from dual 
union all
select 'b' col1,3 col2 from dual 
union all
select 'c' col1,4 col2 from dual 
union all
select 'd' col1,2 col2 from dual 
)
select col1,col2,res from a,(select sum(col2) res from a)

[学海无涯-回头是岸]

select a.*,b.hj from a cross jion (select sum(a.bb) as hj from a) b

[Z_B_Hrunqian]

直接用sum() over() with a as (select 'a' col1,1 col2 from dual union all select 'b' col1,3 col2 from dual union all select 'c' col1,4 col2 from dual union all select 'd' col1,2 col2 from dual ) select col1,col2,sum(col2) over() from a

[qq_3952]

我的图片呢，咋不见了

[qq_3952]

图1 是代码，图2是查询结果。

[qq_3952]

with temp as (select 'a'goods, l nums from dual union all select 'b' goods, 2 nums from dual union all select 'c' goods, 3 nums from dual union all select 'd' goods, 4 nums from dual) select goods商品 nums 销售数量 Sum(nums)over( order by1)合计 from temp;