Top Description Methods
org.jooq

public Interface WindowExcludeStep<T>

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

Deprecated

as a consequence of WindowFinalStep 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 WindowFinalStep<T>
excludeCurrentRow()

Deprecated as a consequence of WindowFinalStep being deprecated.
Add an EXCLUDE CURRENT ROW clause.
public @NotNull WindowFinalStep<T>
excludeGroup()

Deprecated as a consequence of WindowFinalStep being deprecated.
Add an EXCLUDE GROUP clause.
public @NotNull WindowFinalStep<T>
excludeNoOthers()

Deprecated as a consequence of WindowFinalStep being deprecated.
Add an EXCLUDE NO OTHERS clause.
public @NotNull WindowFinalStep<T>
excludeTies()

Deprecated as a consequence of WindowFinalStep being deprecated.
Add an EXCLUDE TIES clause.

Method Detail

excludeCurrentRowback to summary
public @NotNull WindowFinalStep<T> excludeCurrentRow()

Deprecated

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

Add an EXCLUDE CURRENT ROW clause.

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
excludeGroupback to summary
public @NotNull WindowFinalStep<T> excludeGroup()

Deprecated

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

Add an EXCLUDE GROUP clause.

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB
excludeNoOthersback to summary
public @NotNull WindowFinalStep<T> excludeNoOthers()

Deprecated

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

Add an EXCLUDE NO OTHERS clause.

Annotations
@NotNull
@Support:H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
excludeTiesback to summary
public @NotNull WindowFinalStep<T> excludeTies()

Deprecated

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

Add an EXCLUDE TIES clause.

Annotations
@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB