Interface WindowDefinition

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 (see SelectWindowStep.window(WindowDefinition...)
• referenced from the OVER clause (see WindowOverStep.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 Type	Method	Description
@NotNull Name	$name()	Experimental query object model accessor method, see also QOM.
@Nullable WindowSpecification	$windowSpecification()	Experimental query object model accessor method, see also QOM.

Methods inherited from interface QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Methods inherited from interface WindowSpecification

$exclude, $exclude, $frameEnd, $frameEnd, $frameStart, $frameStart, $frameUnits, $frameUnits, $orderBy, $orderBy, $partitionBy, $partitionBy, $windowDefinition

Methods inherited from interface WindowSpecificationOrderByStep

orderBy, orderBy

Methods inherited from interface 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

Method Details

$name

@Experimental
@NotNull
@NotNull Name $name()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

$windowSpecification

@Experimental
@Nullable
@Nullable WindowSpecification $windowSpecification()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.