window_many.sql 226 B

1234
  1. insert into plato.Output
  2. select key, row_number() over w1, lag(value) over w1, lead(value) over w1,
  3. rank(value) over w2, dense_rank(value) over w2
  4. from plato.Input window w1 as (order by key), w2 as (order by key desc)