-
- All Superinterfaces:
QueryPart
,Serializable
,WindowSpecification
,WindowSpecificationFinalStep
,WindowSpecificationOrderByStep
,WindowSpecificationRowsStep
public interface WindowDefinition extends WindowSpecificationOrderByStep
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 bySQLDialect.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
-
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
-
-