jOOQ 3.18.7 · org.jooq.WindowSpecificationPartitionByStep

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:

They're operating on mutable implementations (as of jOOQ 3.x)
They're less composable and not easy to get right when dynamic SQL gets complex
They're less readable
They might have binary incompatible changes between minor releases

Method Summary

Modifier and Type	Method and Description
public @NotNull WindowSpecificationOrderByStep	partitionBy(GroupField... fields) Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. Add a `PARTITION BY` clause to the window specification.
public @NotNull WindowSpecificationOrderByStep	partitionBy(Collection<? extends GroupField> fields) Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. Add a `PARTITION BY` clause to the window specification.
public @NotNull WindowSpecificationOrderByStep	partitionByOne() Deprecated for removal since 3.10. - 3.10 - [#6427] - This synthetic clause is no longer supported, use `partitionBy(GroupField...)` instead, or omit the clause entirely. Add a `PARTITION BY 1` clause to the window specification, where such a clause is required by the syntax of an RDBMS.

Inherited from org.jooq.WindowSpecificationOrderByStep:: orderBy orderBy

Method Detail

partitionBy back to summary

partitionBy	back to summary
public @NotNull WindowSpecificationOrderByStep partitionBy(GroupField... fields) Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. See corresponding docs for further information. Add a `PARTITION BY` clause to the window specification. Annotations @NotNull @Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowSpecificationOrderByStep partitionBy(GroupField... fields)

Deprecated

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

Add a PARTITION BY clause to the window specification.

Annotations

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

partitionBy back to summary

partitionBy	back to summary
public @NotNull WindowSpecificationOrderByStep partitionBy(Collection<? extends GroupField> fields) Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. See corresponding docs for further information. Add a `PARTITION BY` clause to the window specification. Annotations @NotNull @Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowSpecificationOrderByStep partitionBy(Collection<? extends GroupField> fields)

Deprecated

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

Add a PARTITION BY clause to the window specification.

Annotations

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

partitionByOne back to summary

partitionByOne	back to summary
public @NotNull WindowSpecificationOrderByStep partitionByOne() Deprecated for removal since 3.10. - 3.10 - [#6427] - This synthetic clause is no longer supported, use `partitionBy(GroupField...)` instead, or omit the clause entirely. Add a `PARTITION BY 1` clause to the window specification, where such a clause is required by the syntax of an RDBMS. Annotations @Deprecated forRemoval:true since:3.10 @NotNull @Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowSpecificationOrderByStep partitionByOne()

Deprecated

for removal since 3.10.

- 3.10 - [#6427] - This synthetic clause is no longer supported, use partitionBy(GroupField...) instead, or omit the clause entirely.

Add a PARTITION BY 1 clause to the window specification, where such a clause is required by the syntax of an RDBMS.

Annotations

@Deprecated
forRemoval:true
since:3.10
@NotNull
@Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public Interface WindowSpecificationPartitionByStep

Referencing XYZ*Step types directly from client code

Method Summary

Method Detail

Referencing `XYZ*Step` types directly from client code