123456789 |
- /* 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;
|