On Mon, Dec 18, 2017 at 9:56 AM, Edson Carlos Ericksson Richter <
rich...@simkorp.com.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.​

Reply via email to