-
LEAD() : -
LEAD(expression, offset, default) -
LAG() : -
LAG(expression, offset, default) -
ROW_NUMBER() : -
ROW_NUMBER() OVER (PARTITION BY partition_expression ORDER BY order_expression) -
RANK() : -
RANK() OVER (PARTITION BY partition_expression ORDER BY order_expression) -
FIRST_VALUE() : -
FIRST_VALUE(expression) OVER (PARTITION BY partition_expression ORDER BY order_expression)