数据湖探索 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