【数据库】pgsql窗口函数，分组求sum的方式

本文主要是介绍【数据库】pgsql窗口函数，分组求sum的方式，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

select distinct
    quantity,
    standard_cost,
    sum(a.quantity*a.standard_cost) over(partition by purchase_scence_code,raw_material_code) amount,
     coalesce(purchase_scence_code,'unknown') as purchase_scence_code,
    coalesce(raw_material_code,'unknown') as raw_material_code
from ap.fact_outbound_order as a 
where
    a.material_type_code='3'
    and
    quantity<0

select
        purchase_scence_code,
        sum(amount)
from (
        select distinct
                quantity,
                standard_cost,
                sum(a.quantity*a.standard_cost) over(partition by purchase_scence_code,raw_material_code) amount,
                coalesce(purchase_scence_code,'unknown') as purchase_scence_code,
                coalesce(raw_material_code,'unknown') as raw_material_code
        from ap.fact_outbound_order as a 
        where a.material_type_code='3'
) t1
group by t1.purchase_scence_code

这篇关于【数据库】pgsql窗口函数，分组求sum的方式的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！