Package org.jooq

Interface WindowDefinition

All Superinterfaces:

QueryPart, java.io.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

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

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