English |

简体中文

api-docs / org.ktorm.expression / WindowFunctionType

WindowFunctionType

enum class WindowFunctionType (source code)

The enum of window function type.

Since
3.6.0

Enum Values

Name	Summary
MIN	The min function, translated to `min(column)` in SQL.
MAX	The max function, translated to `max(column)` in SQL.
AVG	The avg function, translated to `avg(column)` in SQL.
SUM	The sum function, translated to `sum(column)` in SQL.
COUNT	The count function, translated to `count(column)` in SQL.
ROW_NUMBER	The row_number function, translated to `row_number()` in SQL.
RANK	The rank function, translated to `rank()` in SQL.
DENSE_RANK	The dense_rank function, translated to `dense_rank()` in SQL.
PERCENT_RANK	The percent_rank function, translated to `percent_rank()` in SQL.
CUME_DIST	The cume_dist function, translated to `cume_dist()` in SQL.
LAG	The lag function, translated to `lag(column, offset, default_value)` in SQL.
LEAD	The lead function, translated to `lead(column, offset, default_value)` in SQL.
FIRST_VALUE	The first_value function, translated to `first_value(column)` in SQL.
LAST_VALUE	The last_value function, translated to `last_value(column)` in SQL.
NTH_VALUE	The nth_value function, translated to `nth_value(column, n)` in SQL.
NTILE	The ntile function, translated to `ntile(n)` in SQL.

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.