org.jooq

Interface WindowSpecificationPartitionByStep

All Superinterfaces:

QueryPart, Serializable, WindowSpecification, WindowSpecificationFinalStep, WindowSpecificationOrderByStep, WindowSpecificationRowsStep

public interface WindowSpecificationPartitionByStep
extends WindowSpecificationOrderByStep

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

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
WindowSpecificationOrderByStep	partitionBy(Collection<? extends Field<?>> fields) Add a PARTITION BY clause to the window specification.
WindowSpecificationOrderByStep	partitionBy(Field<?>... fields) Add a PARTITION BY clause to the window specification.
WindowSpecificationOrderByStep	partitionByOne() Deprecated. - 3.10 - [#6427] - This synthetic clause is no longer supported, use partitionBy(Field...) instead, or omit the clause entirely.

Methods inherited from interface org.jooq.WindowSpecificationOrderByStep

orderBy, orderBy

Methods inherited from interface org.jooq.WindowSpecificationRowsStep

rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

partitionBy

@Support(value={AURORA_POSTGRES,CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
WindowSpecificationOrderByStep partitionBy(Field<?>... fields)

Add a PARTITION BY clause to the window specification.

partitionBy

@Support(value={AURORA_POSTGRES,CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
WindowSpecificationOrderByStep partitionBy(Collection<? extends Field<?>> fields)

Add a PARTITION BY clause to the window specification.

partitionByOne

@Deprecated
 @Support(value={AURORA_POSTGRES,CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
WindowSpecificationOrderByStep partitionByOne()

Deprecated. - 3.10 - [#6427] - This synthetic clause is no longer supported, use partitionBy(Field...) 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.

This clause is not supported as such in the CUBRID and Sybase dialects. If you use it, jOOQ will simply ignore it.