WindowFunctionType

The enum of window function type.

Since

3.6.0

Entries

Link copied to clipboard

The min function, translated to min(column) in SQL.

Link copied to clipboard

The max function, translated to max(column) in SQL.

Link copied to clipboard

The avg function, translated to avg(column) in SQL.

Link copied to clipboard

The sum function, translated to sum(column) in SQL.

Link copied to clipboard

The count function, translated to count(column) in SQL.

Link copied to clipboard

The row_number function, translated to row_number() in SQL.

Link copied to clipboard

The rank function, translated to rank() in SQL.

Link copied to clipboard

The dense_rank function, translated to dense_rank() in SQL.

Link copied to clipboard

The percent_rank function, translated to percent_rank() in SQL.

Link copied to clipboard

The cume_dist function, translated to cume_dist() in SQL.

Link copied to clipboard

The lag function, translated to lag(column, offset, default_value) in SQL.

Link copied to clipboard

The lead function, translated to lead(column, offset, default_value) in SQL.

Link copied to clipboard

The first_value function, translated to first_value(column) in SQL.

Link copied to clipboard

The last_value function, translated to last_value(column) in SQL.

Link copied to clipboard

The nth_value function, translated to nth_value(column, n) in SQL.

Link copied to clipboard

The ntile function, translated to ntile(n) in SQL.

Properties

Link copied to clipboard

Returns a representation of an immutable list of all enum entries, in the order they're declared.

Link copied to clipboard
Link copied to clipboard

Functions

Link copied to clipboard
open override fun toString(): String
Link copied to clipboard

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Link copied to clipboard

Returns an array containing the constants of this enum type, in the order they're declared.