yql/essentials/tests/sql/suites/column_order/winfunc.sql


1
2
3
4
5
6
7
8
9

use plato;
pragma OrderedColumns; 

select 
    a.*
    , lag(key) over (order by subkey) as prev_k
    , min(key) over (order by subkey) as min_k
from Input as a
order by subkey