Top Description Methods
org.jooq

public Interface WindowSpecificationRowsAndStep

Known Direct Implementers
org.jooq.impl.WindowSpecificationImpl
Static Imports
org.jooq.SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

An intermediate step in the construction of a WindowSpecification.

Example:


WindowSpecification spec =
DSL.partitionBy(BOOK.AUTHOR_ID)
   .orderBy(BOOK.ID)
   .rowsBetweenUnboundedPreceding()
   .andCurrentRow();

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull WindowSpecificationExcludeStep
andCurrentRow()

Deprecated as a consequence of WindowSpecificationExcludeStep being deprecated.
Add a … AND CURRENT ROW frame clause to the window specification.
public @NotNull WindowSpecificationExcludeStep
andFollowing(int number)

Deprecated as a consequence of WindowSpecificationExcludeStep being deprecated.
Add a … AND [number] FOLLOWING frame clause to the window specification.
public @NotNull WindowSpecificationExcludeStep
andPreceding(int number)

Deprecated as a consequence of WindowSpecificationExcludeStep being deprecated.
Add a … AND [number] PRECEDING frame clause to the window specification.
public @NotNull WindowSpecificationExcludeStep
andUnboundedFollowing()

Deprecated as a consequence of WindowSpecificationExcludeStep being deprecated.
Add a … AND UNBOUNDED FOLLOWING frame clause to the window specification.
public @NotNull WindowSpecificationExcludeStep
andUnboundedPreceding()

Deprecated as a consequence of WindowSpecificationExcludeStep being deprecated.
Add a … AND UNBOUNDED PRECEDING frame clause to the window specification.

Method Detail

andCurrentRowback to summary
public @NotNull WindowSpecificationExcludeStep andCurrentRow()

Deprecated

as a consequence of WindowSpecificationExcludeStep being deprecated. See corresponding docs for further information.

Add a … AND CURRENT ROW frame clause to the window specification.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andFollowingback to summary
public @NotNull WindowSpecificationExcludeStep andFollowing(int number)

Deprecated

as a consequence of WindowSpecificationExcludeStep being deprecated. See corresponding docs for further information.

Add a … AND [number] FOLLOWING frame clause to the window specification.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andPrecedingback to summary
public @NotNull WindowSpecificationExcludeStep andPreceding(int number)

Deprecated

as a consequence of WindowSpecificationExcludeStep being deprecated. See corresponding docs for further information.

Add a … AND [number] PRECEDING frame clause to the window specification.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andUnboundedFollowingback to summary
public @NotNull WindowSpecificationExcludeStep andUnboundedFollowing()

Deprecated

as a consequence of WindowSpecificationExcludeStep being deprecated. See corresponding docs for further information.

Add a … AND UNBOUNDED FOLLOWING frame clause to the window specification.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andUnboundedPrecedingback to summary
public @NotNull WindowSpecificationExcludeStep andUnboundedPreceding()

Deprecated

as a consequence of WindowSpecificationExcludeStep being deprecated. See corresponding docs for further information.

Add a … AND UNBOUNDED PRECEDING frame clause to the window specification.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB