English |

简体中文

api-docs / org.ktorm.expression / AggregateType

AggregateType

enum class AggregateType (source code)

The enum of aggregate functions in a AggregateExpression.

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.

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.