数据湖探索 DLI-OVER子句:语法格式

时间:2024-07-01 21:07:21

语法格式

1
2
3
4
5
SELECT window_func(args) OVER
  ([PARTITION BY col_name, col_name, ...]
   [ORDER BY col_name, col_name, ...]
   [ROWS | RANGE BETWEEN (CURRENT ROW | (UNBOUNDED |[num]) PRECEDING)
  AND (CURRENT ROW | ( UNBOUNDED | [num]) FOLLOWING)]);
support.huaweicloud.com/sqlreference-dli/dli_08_0190.html