api-docs / org.ktorm.expression / WindowSpecificationExpression
WindowSpecificationExpression
data class WindowSpecificationExpression : SqlExpression
(source code)Window specification expression.
Constructors
Name | Summary |
---|---|
WindowSpecificationExpression( Window specification expression. |
Properties
Name | Summary |
---|---|
Extra properties of this expression, maybe useful in SqlFormatter to generate some special SQLs. | |
val frameEnd: WindowFrameBoundExpression? end bound of the window frame. | |
val frameStart: WindowFrameBoundExpression? start bound of the window frame. | |
val frameUnit: WindowFrameUnitType? frame unit indicates the type of relationship between the current row and frame rows. | |
val isLeafNode: Boolean Check if this expression is a leaf node in expression trees. | |
val orderBy: List<OrderByExpression> order-by clause indicates how to sort rows in each partition. | |
val partitionBy: List<ScalarExpression<*>> partition-by clause indicates how to divide the query rows into groups. |
Extension Functions
Name | Summary |
---|---|
infix fun <T : Any> T.eq( Equal operator, translated to | |
infix fun <T : Any> T.neq( Not-equal operator, translated to | |
infix fun <T : Any> T.notEq( Not-equal operator, translated to | |
fun WindowSpecificationExpression.orderBy( fun WindowSpecificationExpression.orderBy( Specify the order-by clause of this window using the given order-by expressions. | |
fun WindowSpecificationExpression.partitionBy( fun WindowSpecificationExpression.partitionBy( Specify the partition-by clause of this window using the given columns or expressions. | |
fun WindowSpecificationExpression.range( Specify the frame clause of this window using the given bound in range unit. | |
fun WindowSpecificationExpression.rangeBetween( Specify the frame clause of this window using the given bounds (start & end) in rows unit. | |
fun WindowSpecificationExpression.rows( Specify the frame clause of this window using the given bound in rows unit. | |
fun WindowSpecificationExpression.rowsBetween( Specify the frame clause of this window using the given bounds (start & end) in rows unit. |