- All Superinterfaces:
QueryPart
,Serializable
- All Known Subinterfaces:
WindowDefinition
,WindowSpecificationExcludeStep
,WindowSpecificationFinalStep
,WindowSpecificationOrderByStep
,WindowSpecificationPartitionByStep
,WindowSpecificationRowsStep
A window specification.
Window specifications are the syntactic clauses that can be passed to both
window definitions in WINDOW
clauses, as well as to the
OVER
clause of window functions. This makes window
specifications highly reusable across several queries.
Example:
WindowSpecification spec =
DSL.partitionBy(BOOK.AUTHOR_ID)
.orderBy(BOOK.ID)
.rowsBetweenUnboundedPreceding()
.andCurrentRow();
Instances can be created using DSL.partitionBy(GroupField...)
,
DSL.orderBy(OrderField...)
, and overloads as well as rows / range /
groups related methods in DSL
.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@Nullable QOM.FrameExclude
$exclude()
Experimental query object model accessor method, see alsoQOM
.@Nullable Integer
Experimental query object model accessor method, see alsoQOM
.@Nullable Integer
Experimental query object model accessor method, see alsoQOM
.@Nullable QOM.FrameUnits
Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends SortField<?>>
$orderBy()
Experimental query object model accessor method, see alsoQOM
.@NotNull QOM.UnmodifiableList<? extends GroupField>
Experimental query object model accessor method, see alsoQOM
.@Nullable WindowDefinition
Experimental query object model accessor method, see alsoQOM
.
-
Method Details
-
$windowDefinition
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$partitionBy
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$orderBy
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$frameUnits
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$frameStart
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$frameEnd
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$exclude
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk.
-