distinct_window.sql 226 B

12345678
  1. /* syntax version 1 */
  2. use plato;
  3. select distinct AGGREGATE_LIST(value) over w as values, key from Input2
  4. window w as (partition by key order by value rows between unbounded preceding and unbounded following)
  5. order by key;