Top Description Methods
org.jooq

public Interface WindowSpecificationRowsStep

extends WindowSpecificationFinalStep
Known Direct Subinterfaces
org.jooq.WindowSpecificationOrderByStep
Static Imports
org.jooq.SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

Deprecated

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

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 WindowSpecificationRowsAndStep
groupsBetweenCurrentRow()

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

public @NotNull WindowSpecificationRowsAndStep
groupsBetweenFollowing(int number)

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

public @NotNull WindowSpecificationRowsAndStep
groupsBetweenPreceding(int number)

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

public @NotNull WindowSpecificationRowsAndStep
groupsBetweenUnboundedFollowing()

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

public @NotNull WindowSpecificationRowsAndStep
groupsBetweenUnboundedPreceding()

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

public @NotNull WindowSpecificationExcludeStep
groupsCurrentRow()

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

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

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

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

Deprecated as a consequence of WindowSpecificationExcludeStep being deprecated.
Add a GROUPS UNBOUNDED PRECEDING frame clause to the window specification.
public @NotNull WindowSpecificationRowsAndStep
rangeBetweenCurrentRow()

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

public @NotNull WindowSpecificationRowsAndStep
rangeBetweenFollowing(int number)

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

public @NotNull WindowSpecificationRowsAndStep
rangeBetweenPreceding(int number)

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

public @NotNull WindowSpecificationRowsAndStep
rangeBetweenUnboundedFollowing()

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

public @NotNull WindowSpecificationRowsAndStep
rangeBetweenUnboundedPreceding()

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

public @NotNull WindowSpecificationExcludeStep
rangeCurrentRow()

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

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

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

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

Deprecated as a consequence of WindowSpecificationExcludeStep being deprecated.
Add a RANGE UNBOUNDED PRECEDING frame clause to the window specification.
public @NotNull WindowSpecificationRowsAndStep
rowsBetweenCurrentRow()

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

public @NotNull WindowSpecificationRowsAndStep
rowsBetweenFollowing(int number)

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

public @NotNull WindowSpecificationRowsAndStep
rowsBetweenPreceding(int number)

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

public @NotNull WindowSpecificationRowsAndStep
rowsBetweenUnboundedFollowing()

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

public @NotNull WindowSpecificationRowsAndStep
rowsBetweenUnboundedPreceding()

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

public @NotNull WindowSpecificationExcludeStep
rowsCurrentRow()

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

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

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

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

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

Method Detail

groupsBetweenCurrentRowback to summary
public @NotNull WindowSpecificationRowsAndStep groupsBetweenCurrentRow()

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

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsBetweenFollowingback to summary
public @NotNull WindowSpecificationRowsAndStep groupsBetweenFollowing(int number)

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

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsBetweenPrecedingback to summary
public @NotNull WindowSpecificationRowsAndStep groupsBetweenPreceding(int number)

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

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsBetweenUnboundedFollowingback to summary
public @NotNull WindowSpecificationRowsAndStep groupsBetweenUnboundedFollowing()

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

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsBetweenUnboundedPrecedingback to summary
public @NotNull WindowSpecificationRowsAndStep groupsBetweenUnboundedPreceding()

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

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsCurrentRowback to summary
public @NotNull WindowSpecificationExcludeStep groupsCurrentRow()

Deprecated

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

Add a GROUPS CURRENT ROW frame clause to the window specification.

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsFollowingback to summary
public @NotNull WindowSpecificationExcludeStep groupsFollowing(int number)

Deprecated

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

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

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsPrecedingback to summary
public @NotNull WindowSpecificationExcludeStep groupsPreceding(int number)

Deprecated

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

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

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsUnboundedFollowingback to summary
public @NotNull WindowSpecificationExcludeStep groupsUnboundedFollowing()

Deprecated

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

Add a GROUPS UNBOUNDED FOLLOWING frame clause to the window specification.

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
groupsUnboundedPrecedingback to summary
public @NotNull WindowSpecificationExcludeStep groupsUnboundedPreceding()

Deprecated

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

Add a GROUPS UNBOUNDED PRECEDING frame clause to the window specification.

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
rangeBetweenCurrentRowback to summary
public @NotNull WindowSpecificationRowsAndStep rangeBetweenCurrentRow()

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rangeBetweenFollowingback to summary
public @NotNull WindowSpecificationRowsAndStep rangeBetweenFollowing(int number)

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rangeBetweenPrecedingback to summary
public @NotNull WindowSpecificationRowsAndStep rangeBetweenPreceding(int number)

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rangeBetweenUnboundedFollowingback to summary
public @NotNull WindowSpecificationRowsAndStep rangeBetweenUnboundedFollowing()

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rangeBetweenUnboundedPrecedingback to summary
public @NotNull WindowSpecificationRowsAndStep rangeBetweenUnboundedPreceding()

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

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

Deprecated

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

Add a RANGE CURRENT ROW frame clause to the window specification.

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

Deprecated

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

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

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

Deprecated

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

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

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

Deprecated

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

Add a RANGE UNBOUNDED FOLLOWING frame clause to the window specification.

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

Deprecated

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

Add a RANGE UNBOUNDED PRECEDING frame clause to the window specification.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rowsBetweenCurrentRowback to summary
public @NotNull WindowSpecificationRowsAndStep rowsBetweenCurrentRow()

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rowsBetweenFollowingback to summary
public @NotNull WindowSpecificationRowsAndStep rowsBetweenFollowing(int number)

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rowsBetweenPrecedingback to summary
public @NotNull WindowSpecificationRowsAndStep rowsBetweenPreceding(int number)

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rowsBetweenUnboundedFollowingback to summary
public @NotNull WindowSpecificationRowsAndStep rowsBetweenUnboundedFollowing()

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

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
rowsBetweenUnboundedPrecedingback to summary
public @NotNull WindowSpecificationRowsAndStep rowsBetweenUnboundedPreceding()

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

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

Deprecated

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

Add a ROWS CURRENT ROW frame clause to the window specification.

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

Deprecated

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

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

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

Deprecated

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

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

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

Deprecated

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

Add a ROWS UNBOUNDED FOLLOWING frame clause to the window specification.

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

Deprecated

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

Add a ROWS UNBOUNDED PRECEDING frame clause to the window specification.

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