Thread: Advice on how to build a query with partial sums

JORGE MALDONADO wrote
> I need to build a query for the sample data below:
>
> -----------------------------------------------------------------------
>  --------
> fte_clave    fte_padre    fte_porc    fte_porc_aux         total
> -----------------------------------------------------------------------
>  --------
> 1                  1                25              25
> 50
> 2                  1                25               0
> 50
> 3                  1                50              25
> 50
>
> 4                  2                20               0
> 40
> 5                  2                20              25
> 40
> 6                  2                60              15
> 40
>
> 7                  3                15              35
> 60
> 8                  3                15               0
> 60
> 9                  3                20               0
> 60
> 10                3                50              25                   60
> -----------------------------------------------------------------------
>  -------
>
> The table contains only the first 4 fields and I want to build a query
> that
> gets such fields plus a fifth one (total) with the sum of "fte_porc_aux"
> for each "fte_padre".
>
> I will very much appreciate your comments.

Look up the concept of "window functions" in the documentation.

Select sum(fte_porc_aux) over (partition by fte_padre) from ...

David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Advice-on-how-to-build-a-query-with-partial-sums-tp5769216p5769226.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.