yql/essentials/tests/sql/suites/distinct/distinct_window.sql


1
2
3
4
5
6
7
8

/* syntax version 1 */

use plato;

select distinct AGGREGATE_LIST(value) over w as values, key from Input2
window w as (partition by key order by value rows between unbounded preceding and unbounded following)
order by key;