blob: 327425fe13e018a47c1873b2c60837ffee6194de [file] [log] [blame]
-- OVER(W) syntax
select
sum(a2) over(w),
count(*) over(partition by a2 order by a2)
from
t2 window w as (partition by a2 order by a2);