win_inline_spec.sql 299 B

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