English |

简体中文

api-docs / org.ktorm.expression / WindowFrameBoundType

WindowFrameBoundType

enum class WindowFrameBoundType (source code)

The enum type of window frame bound.

Since
3.6.0

Enum Values

Name	Summary
CURRENT_ROW	For ROWS, the bound is the current row. For RANGE, the bound is the peers of the current row.
UNBOUNDED_PRECEDING	The bound is the first partition row.
UNBOUNDED_FOLLOWING	The bound is the last partition row.
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.
FOLLOWING	For ROWS, the bound is N rows after the current row. For RANGE, the bound is the rows with values equal to the current row value plus N; if the current row value is NULL, the bound is the peers of the row.

Functions

Name	Summary
toString	`fun toString(): String`

Extension Functions

Name	Summary
eq	`infix fun <T : Any> T.eq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Equal operator, translated to `=` in SQL.
greater	`infix fun <T : Comparable<T>> T.greater( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Greater operator, translated to `>` in SQL.
greaterEq	`infix fun <T : Comparable<T>> T.greaterEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Greater-eq operator, translated to `>=` in SQL.
gt	`infix fun <T : Comparable<T>> T.gt( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Greater operator, translated to `>` in SQL.
gte	`infix fun <T : Comparable<T>> T.gte( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Greater-eq operator, translated to `>=` in SQL.
less	`infix fun <T : Comparable<T>> T.less( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Less operator, translated to `<` in SQL.
lessEq	`infix fun <T : Comparable<T>> T.lessEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Less-eq operator, translated to `<=` in SQL.
lt	`infix fun <T : Comparable<T>> T.lt( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Less operator, translated to `<` in SQL.
lte	`infix fun <T : Comparable<T>> T.lte( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Less-eq operator, translated to `<=` in SQL.
neq	`infix fun <T : Any> T.neq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.
notEq	`infix fun <T : Any> T.notEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.