Deprecated
as a consequence of WindowSpecificationFinalStep being deprecated. See corresponding docs for further information.
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 WindowSpecificationFinalStep | excludeCurrentRow()
Deprecated
as a consequence of
Add an WindowSpecificationFinalStep being deprecated.
EXCLUDE CURRENT ROW clause.
|
| public @NotNull WindowSpecificationFinalStep | excludeGroup()
Deprecated
as a consequence of
Add an WindowSpecificationFinalStep being deprecated.
EXCLUDE GROUP clause.
|
| public @NotNull WindowSpecificationFinalStep | excludeNoOthers()
Deprecated
as a consequence of
Add an WindowSpecificationFinalStep being deprecated.
EXCLUDE NO OTHERS clause.
|
| public @NotNull WindowSpecificationFinalStep | excludeTies()
Deprecated
as a consequence of
Add an WindowSpecificationFinalStep being deprecated.
EXCLUDE TIES clause.
|
| excludeCurrentRow | back to summary |
|---|---|
| public @NotNull WindowSpecificationFinalStep excludeCurrentRow()
Deprecated as a consequence of Add an | |
| excludeGroup | back to summary |
|---|---|
| public @NotNull WindowSpecificationFinalStep excludeGroup()
Deprecated as a consequence of Add an | |
| excludeNoOthers | back to summary |
|---|---|
| public @NotNull WindowSpecificationFinalStep excludeNoOthers()
Deprecated as a consequence of Add an | |
| excludeTies | back to summary |
|---|---|
| public @NotNull WindowSpecificationFinalStep excludeTies()
Deprecated as a consequence of Add an | |