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