On Mon, Dec 18, 2017 at 11:01 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
Do you mean:SELECT id, val, val / (sum(val) OVER ())FROM vals;
You could end up with a percentage > 100 or divide by 0 with that if the values are not in a proper range. I don't know if that would be the intention.
