Em 18/12/2017 15:01, David G. Johnston escreveu:
On Mon, Dec 18, 2017 at 9:56 AM, Edson Carlos Ericksson Richter
<rich...@simkorp.com.br <mailto: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.
I've never thought about Window Functions that way.
Thanks, it is enligthning.
:-)
Regards,
Edson.
