lead(expr [, offset] [, default]) OVER([partition_by_clause] order_by_clause)
This function returns the value of an expression using column values from a following row. You specify an integer offset, which designates a row position some number of rows after to the current row. Any column references in the expression argument refer to column values from that later row.
替换
lag(expr [, offset] [, default]) OVER ([partition_by_clause] order_by_clause)
This function returns the value of an expression using column values from a preceding row. You specify an integer offset, wh