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