blob: b881a0768958db3359d0d3b7b61d5cba21f3435a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
/* syntax version 1 */
select
key,
max(key) over (order by key) as running_max,
lead(key) over (order by key rows unbounded preceding) as next_key,
aggregate_list(key) over w as keys,
from plato.Input
window w as (order by key rows between unbounded preceding and current row)
order by key;
|
