win_func_aggr_4func.sql 258 B

123456789
  1. /* postgres can not */
  2. select
  3. subkey,
  4. 2 * sum(cast(key as uint32)) over w1 as dbl_sum,
  5. count(key) over w1 as c,
  6. min(key) over w1 as mink,
  7. max(key) over w1 as maxk
  8. from plato.Input window w1 as (partition by subkey order by key)
  9. order by subkey, c;