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

时间:2025-02-12 14:55:44

语法格式

12345
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/sqlref-spark-dli/dli_08_0190.html