English | 简体中文

api-docs / org.ktorm.dsl / WindowFrames / preceding

preceding

inline fun <reified T : Number> preceding(
    n: T,
    sqlType: SqlType<T> = SqlType.of() ?: error("Cannot detect the argument's SqlType, please specify manually.")
): WindowFrameBoundExpression
(source code)

Create a bound expression that represents N preceding.

For ROWS, the bound is n rows before the current row. For RANGE, the bound is the rows with values equal to
the current row value minus n; if the current row value is NULL, the bound is the peers of the row.

Since
3.6.0