- All Superinterfaces:
QueryPart
,Serializable
,WindowSpecification
,WindowSpecificationFinalStep
,WindowSpecificationOrderByStep
,WindowSpecificationRowsStep
A window definition.
Window definitions can be
- declared in the
WINDOW
clause (seeSelectWindowStep.window(WindowDefinition...)
- referenced from the
OVER
clause (seeWindowOverStep.over(WindowDefinition)
The WINDOW
clause is only natively supported by
SQLDialect.AURORA_POSTGRES
SQLDialect.H2
SQLDialect.MYSQL
SQLDialect.POSTGRES
SQLDialect.SQLITE
SQLDialect.SYBASE
If your database supports window functions, but not the WINDOW
clause, jOOQ will inline window definitions into their respective window
functions.
Instances can be created using Name.as(WindowSpecification)
and
overloads.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull Name
$name()
Experimental query object model accessor method, see alsoQOM
.@Nullable WindowSpecification
Experimental query object model accessor method, see alsoQOM
.Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, equals, hashCode, toString
Methods inherited from interface org.jooq.WindowSpecification
$exclude, $frameEnd, $frameStart, $frameUnits, $orderBy, $partitionBy, $windowDefinition
Methods inherited from interface org.jooq.WindowSpecificationOrderByStep
orderBy, orderBy
Methods inherited from interface org.jooq.WindowSpecificationRowsStep
groupsBetweenCurrentRow, groupsBetweenFollowing, groupsBetweenPreceding, groupsBetweenUnboundedFollowing, groupsBetweenUnboundedPreceding, groupsCurrentRow, groupsFollowing, groupsPreceding, groupsUnboundedFollowing, groupsUnboundedPreceding, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding