yt/yql/tests/sql/suites/column_order/select_win_func.yql


1
2
3
4
5
6
7
8
9
10
11

/* postgres can not */
/* syntax version 1 */
use plato;
pragma OrderedColumns;

select
  min(subkey) over (partition by key) as zz,
  row_number() over (order by key, subkey) as z,
  a.*
from Input as a
order by key, subkey;