Top Description Methods
org.jooq

public Interface WindowRowsAndStep<T>

Known Direct Implementers
org.jooq.impl.AbstractWindowFunction
Type Parameters
<T>
The function return type
Static Imports
org.jooq.SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB
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 WindowExcludeStep<T>
andCurrentRow()

Deprecated as a consequence of WindowExcludeStep being deprecated.
Add a … AND CURRENT ROW frame clause to the window function.
public @NotNull WindowExcludeStep<T>
andFollowing(int number)

Deprecated as a consequence of WindowExcludeStep being deprecated.
Add a … AND [number] FOLLOWING frame clause to the window function.
public @NotNull WindowExcludeStep<T>
andPreceding(int number)

Deprecated as a consequence of WindowExcludeStep being deprecated.
Add a … AND [number] PRECEDING frame clause to the window function.
public @NotNull WindowExcludeStep<T>
andUnboundedFollowing()

Deprecated as a consequence of WindowExcludeStep being deprecated.
Add a … AND UNBOUNDED FOLLOWING frame clause to the window function.
public @NotNull WindowExcludeStep<T>
andUnboundedPreceding()

Deprecated as a consequence of WindowExcludeStep being deprecated.
Add a … AND UNBOUNDED PRECEDING frame clause to the window function.

Method Detail

andCurrentRowback to summary
public @NotNull WindowExcludeStep<T> andCurrentRow()

Deprecated

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

Add a … AND CURRENT ROW frame clause to the window function.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andFollowingback to summary
public @NotNull WindowExcludeStep<T> andFollowing(int number)

Deprecated

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

Add a … AND [number] FOLLOWING frame clause to the window function.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andPrecedingback to summary
public @NotNull WindowExcludeStep<T> andPreceding(int number)

Deprecated

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

Add a … AND [number] PRECEDING frame clause to the window function.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andUnboundedFollowingback to summary
public @NotNull WindowExcludeStep<T> andUnboundedFollowing()

Deprecated

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

Add a … AND UNBOUNDED FOLLOWING frame clause to the window function.

Annotations
@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
andUnboundedPrecedingback to summary
public @NotNull WindowExcludeStep<T> andUnboundedPreceding()

Deprecated

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

Add a … AND UNBOUNDED PRECEDING frame clause to the window function.

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