Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table foo as select 1 as id, 10 as weight
1 rows affected

SELECT id, sum(weight) OVER w
FROM foo
-- Use random() to break ties
WINDOW w AS (ORDER BY weight DESC, random())
ORDER BY 2
LIMIT 1;


id
sum


1
10


SELECT id, sum(weight) OVER w
FROM foo
-- Use random() to break ties
WINDOW w AS (ORDER BY weight DESC, random())
ORDER BY w
LIMIT 1;
ERROR:  column "w" does not exist
LINE 5: ORDER BY w
                 ^