On Mon, Dec 18, 2017 at 9:56 AM, Edson Carlos Ericksson Richter <richter@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.
I've never thought about Window Functions that way. Thanks, it is enligthning.