On Mon, Dec 18, 2017 at 9:56 AM, Edson Carlos Ericksson Richter <
richter(at)simkorp(dot)com(dot)br> wrote:
> But, is it possible to have a aggregate function that calculates de
> percent from the sum (and/or count) total (as a value from 0 ... 1) for
> numeric (or double)?
>
Do you mean:
SELECT id, val, val / (sum(val) OVER ())
FROM vals;
David J.