WindowSpecification.
Example:
WindowSpecification spec =
DSL.partitionBy(BOOK.AUTHOR_ID)
.orderBy(BOOK.ID)
.rowsBetweenUnboundedPreceding()
.andCurrentRow();
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:
| Modifier and Type | Method and Description |
|---|---|
| public @NotNull WindowSpecificationExcludeStep | andCurrentRow()
Deprecated
as a consequence of
Add a WindowSpecificationExcludeStep being deprecated.
… AND CURRENT ROW frame clause to the window
specification.
|
| public @NotNull WindowSpecificationExcludeStep | andFollowing(int number)
Deprecated
as a consequence of
Add a WindowSpecificationExcludeStep being deprecated.
… AND [number] FOLLOWING frame clause to the window
specification.
|
| public @NotNull WindowSpecificationExcludeStep | andPreceding(int number)
Deprecated
as a consequence of
Add a WindowSpecificationExcludeStep being deprecated.
… AND [number] PRECEDING frame clause to the window
specification.
|
| public @NotNull WindowSpecificationExcludeStep | andUnboundedFollowing()
Deprecated
as a consequence of
Add a WindowSpecificationExcludeStep being deprecated.
… AND UNBOUNDED FOLLOWING frame clause to the window
specification.
|
| public @NotNull WindowSpecificationExcludeStep | andUnboundedPreceding()
Deprecated
as a consequence of
Add a WindowSpecificationExcludeStep being deprecated.
… AND UNBOUNDED PRECEDING frame clause to the window
specification.
|
| andCurrentRow | back to summary |
|---|---|
| public @NotNull WindowSpecificationExcludeStep andCurrentRow()
Deprecated as a consequence of Add a | |
| andFollowing | back to summary |
|---|---|
| public @NotNull WindowSpecificationExcludeStep andFollowing(int number)
Deprecated as a consequence of Add a | |
| andPreceding | back to summary |
|---|---|
| public @NotNull WindowSpecificationExcludeStep andPreceding(int number)
Deprecated as a consequence of Add a | |
| andUnboundedFollowing | back to summary |
|---|---|
| public @NotNull WindowSpecificationExcludeStep andUnboundedFollowing()
Deprecated as a consequence of Add a | |
| andUnboundedPreceding | back to summary |
|---|---|
| public @NotNull WindowSpecificationExcludeStep andUnboundedPreceding()
Deprecated as a consequence of Add a | |