WindowFrames

Utility object that creates expressions of window frame bounds.

Since

3.6.0

Functions

Link copied to clipboard

Create a bound expression that represents current row.

Link copied to clipboard
inline fun <T : Number> following(n: T, sqlType: SqlType<T> = SqlType.of() ?: error("Cannot detect the argument's SqlType, please specify manually.")): WindowFrameBoundExpression

Create a bound expression that represents N following.

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

Create a bound expression that represents N preceding.

Link copied to clipboard

Create a bound expression that represents unbounded following, which means the last partition row.

Link copied to clipboard

Create a bound expression that represents unbounded preceding, which means the first partition row.