lag
fun <T : Any> lag(expr: ColumnDeclaring<T>, offset: Int = 1, defVal: T? = null): WindowFunctionExpression<T>(source)
fun <T : Any> lag(expr: ColumnDeclaring<T>, offset: Int, defVal: ColumnDeclaring<T>): WindowFunctionExpression<T>(source)
The lag window function, translated to lag(expr, offset[, defVal]) in SQL.
Return the value of expr from the row that lags (precedes) the current row by offset rows within its partition. If there is no such row, the return value is defVal. For example, if offset is 3, the return value is default for the first three rows.
Since
3.6.0
