win_with_cur_row.sql 266 B

12345678
  1. /* postgres can not */
  2. $data = (select cast(key as uint32) as age, cast(subkey as uint32) as region, value as name from plato.Input);
  3. select
  4. region, name, sum(age) over w1 as sum1
  5. from $data
  6. window w1 as (partition by region order by name)
  7. order by region, name;