我正在寻找正确的查询,它将允许我在一行中显示不同事务的总结果。
我的查询如下
select
porch.jspo# as PO,
porch.jslin# as Line,
porch.jsqtyr as QTY,
sum(porch.JSQTYR) over (partition by porch.JSPO#) as TotalQty
from PORCH
where JSPO# = '109394'
and JSPLNT = 'GC'
group by JSPO#, JSLIN#, JSQTYR结果
PO LN QTY TotalTy
109394 1 9.00000 1774.00000
109394 1 20.00000 1774.00000
109394 1 125.00000 1774.00000
109394 1 400.00000 1774.00000
109394 1 1220.00000 1774.00000我正在寻找一个查询,将求和下所有的交易数量显示这样的结果。
PO LN QTY
109394 1 1774.00000发布于 2020-11-06 00:43:48
这样,就不需要窗口函数了。只需从select和group by子句中删除数量,并使用简单聚合:
select jspo# as po, jslin# as line, sum(jsqtyr) as qty
from porch
where jspo# = '109394' and jsplnt = 'GC'
group by jspo#, jslin#发布于 2020-11-06 00:44:46
应仅按希望在结果集中唯一的列进行聚合。所以:
select porch.jspo# as PO, porch.jslin# as Line,
sum(porch.JSQTYR) as TotalQty
from PORCH
where JSPO# = '109394' and JSPLNT = 'GC'
group by JSPO#, JSLIN#;我不确定您为什么要为此目的尝试累计金额。
https://stackoverflow.com/questions/64701534
复制相似问题