将查询分成3列，并在Apex Oracle中显示另一列的总和
将查询分成3列，并在Apex Oracle中显示另一列的总和
提问于 2020-06-02 15:17:59
我想写一份报告。在我的请求中，这并不困难。我在这个请求中指定了日期和记录类型(正的或负的)。我希望此查询按字段CONTRACTORID、ITEMID组织进行分组。然后在NETTO上取钱。
select
ID, DOCNUMBER,DOCDATE,PRINTNUMBER,DRIVERID,CONTRACTORID,ITEMID,
BRUTTO,TARE,NETTO,
DS_ID,
DAT_A,
MILEAGE,
ORGANIZATION,
sum(NETTO)
from WAYBILL
where trunc(DOCDATE) between to_date(:P115_D1,'dd.mm.yyyy')
and to_date(:P115_D2,'dd.mm.yyyy')
and DIRECTIONID = :P115_DIRECTIONID
group by
ID, DOCNUMBER,DOCDATE,PRINTNUMBER,DRIVERID,CONTRACTORID,ITEMID,
BRUTTO,TARE,NETTO,
DS_ID,
DAT_A,
MILEAGE,
ORGANIZATIONStack Overflow用户
发布于 2020-06-02 15:29:02
看起来您想要显示完整的行，每个行都有对应的合约It、itemid和组织的netto sum。您可以使用窗口函数来实现这一点：
select
id, docnumber, docdate, printnumber, driverid, contractorid, itemid,
brutto, tare, netto, ds_id, dat_a, mileage, organization,
sum(netto) over (partition by contractorid, itemid, organization) as netto_sum
from waybill
where trunc(docdate) between to_date(:p115_d1,'dd.mm.yyyy')
and to_date(:p115_d2,'dd.mm.yyyy')
and directionid = :p115_directionid
order by id;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/62146774
复制相关文章
相似问题
腾讯云开发者
