窗口函数 支持distinct

[colagy]

create table test_window (a int, b int);

insert into test_window values(1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);

select count(distinct a) over(partition by b) from test_window;