yql-14179.sql 151 B

1234567
  1. select
  2. x,
  3. aggregate_list(x) over w as lst,
  4. from (values (1),(2),(3)) as a(x)
  5. window
  6. w as (rows between 0 preceding and 0 preceding)
  7. order by x;