public interface WindowSpecificationOrderByStep extends WindowSpecificationRowsStep
WindowSpecification
.
Example:
WindowSpecification spec =
DSL.partitionBy(BOOK.AUTHOR_ID)
.orderBy(BOOK.ID)
.rowsBetweenUnboundedPreceding()
.andCurrentRow();
Modifier and Type | Method and Description |
---|---|
WindowSpecificationRowsStep |
orderBy(java.util.Collection<? extends OrderField<?>> fields)
Add an
ORDER BY clause to the window specification. |
WindowSpecificationRowsStep |
orderBy(OrderField<?>... fields)
Add an
ORDER BY clause to the window specification. |
rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding
Copyright © 2018. All Rights Reserved.