Top Description Methods
org.jooq

public Interface WindowPartitionByStep<T>

extends WindowOrderByStep<T>
Known Direct Implementers
org.jooq.impl.AbstractWindowFunction
Type Parameters
<T>
The function return type
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

Deprecated

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

This type is used for the window function DSL API.

Example: 


field.firstValue()
     .ignoreNulls()
     .over()
     .partitionBy(AUTHOR_ID)
     .orderBy(PUBLISHED_IN.asc())
     .rowsBetweenUnboundedPreceding()
     .andUnboundedFollowing()
Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull WindowOrderByStep<T>
partitionBy(GroupField... fields)

Deprecated as a consequence of WindowOrderByStep being deprecated.
Add a PARTITION BY clause to the window functions.
public @NotNull WindowOrderByStep<T>
partitionBy(Collection<? extends GroupField> fields)

Deprecated as a consequence of WindowOrderByStep being deprecated.
Add a PARTITION BY clause to the window functions.
public @NotNull WindowOrderByStep<T>
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 functions, where such a clause is required by the syntax of an RDBMS.
Inherited from org.jooq.WindowOrderByStep:
orderByorderBy

Method Detail

partitionByback to summary
public @NotNull WindowOrderByStep<T> partitionBy(GroupField... fields)

Deprecated

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

Add a PARTITION BY clause to the window functions.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
partitionByback to summary
public @NotNull WindowOrderByStep<T> partitionBy(Collection<? extends GroupField> fields)

Deprecated

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

Add a PARTITION BY clause to the window functions.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
partitionByOneback to summary
public @NotNull WindowOrderByStep<T> 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 functions, 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