商品 銷售數量
a 1
b 3
c 4
d 2
希望得到的結果是最后增加一列,是所有商品銷量的合計,盡量不要關聯子查詢
商品 銷售數量 合計
a 1 10
b 3 10
c 4 10
d 2 10
uj5u.com熱心網友回復：
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)
uj5u.com熱心網友回復：
select a.*,b.hj from a cross jion (select sum(a.bb) as hj from a) buj5u.com熱心網友回復：
直接用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
uj5u.com熱心網友回復：
圖1 是代碼，圖2是查詢結果。uj5u.com熱心網友回復：
我的圖片呢，咋不見了uj5u.com熱心網友回復：
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;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/68241.html
標籤：開發
上一篇：pl/sql 中文顯示亂碼