基本语法
SELECT column1, column2, ..., window_function(column) OVER (PARTITION BY partition_column ORDER...基本语法
SELECT column1, column2, ..., ROW_NUMBER() OVER (PARTITION BY partition_column ORDER BY order_column...基本语法
SELECT column1, column2, ..., RANK() OVER (PARTITION BY partition_column ORDER BY order_column)...基本语法
SELECT column1, column2, ..., DENSE_RANK() OVER (PARTITION BY partition_column ORDER BY order_column...基本语法
-- LAG() 语法
LAG(column_name, offset, default_value) OVER (PARTITION BY partition_column ORDER BY