Top Description Methods
org.jooq

public Interface WindowOverStep<T>

Known Direct Subinterfaces
org.jooq.WindowBeforeOverStep, org.jooq.WindowIgnoreNullsStep
Type Parameters
<T>
The function return type
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .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()

Unlike in WindowBeforeOverStep, OVER() is a mandatory clause.

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull WindowPartitionByStep<T>
over()

Deprecated as a consequence of WindowPartitionByStep being deprecated.
Turn this aggregate function into a window function.
public @NotNull WindowFinalStep<T>
over(Name name)

Deprecated as a consequence of WindowFinalStep being deprecated.
Turn this aggregate function into a window function referencing a window name.
public @NotNull WindowFinalStep<T>
over(String name)

Deprecated as a consequence of WindowFinalStep being deprecated.
Turn this aggregate function into a window function referencing a window name.
public @NotNull WindowFinalStep<T>
over(WindowSpecification specification)

Deprecated as a consequence of WindowFinalStep being deprecated.
Turn this aggregate function into a window function.
public @NotNull WindowFinalStep<T>
over(WindowDefinition definition)

Deprecated as a consequence of WindowDefinition and WindowFinalStep being deprecated.
Turn this aggregate function into a window function referencing a window definition.

Method Detail

overback to summary
public @NotNull WindowPartitionByStep<T> over()

Deprecated

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

Turn this aggregate function into a window function.

An example: 


MAX(id) OVER (PARTITION BY 1)
Annotations
@NotNull
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
overback to summary
public @NotNull WindowFinalStep<T> over(Name name)

Deprecated

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

Turn this aggregate function into a window function referencing a window name.

An example: 


MAX(id) OVER my_window

If the WINDOW clause is not supported (see SelectWindowStep#window(WindowDefinition...), then referenced windows will be inlined.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
overback to summary
public @NotNull WindowFinalStep<T> over(String name)

Deprecated

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

Turn this aggregate function into a window function referencing a window name.

An example: 


MAX(id) OVER my_window

If the WINDOW clause is not supported (see SelectWindowStep#window(WindowDefinition...), then referenced windows will be inlined.

Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
overback to summary
public @NotNull WindowFinalStep<T> over(WindowSpecification specification)

Deprecated

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

Turn this aggregate function into a window function.

An example: 


MAX(id) OVER (PARTITION BY 1)
Annotations
@NotNull
@Support:CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
overback to summary
public @NotNull WindowFinalStep<T> over(WindowDefinition definition)

Deprecated

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

Turn this aggregate function into a window function referencing a window definition.

An example: 


MAX(id) OVER my_window

If the WINDOW clause is not supported (see SelectWindowStep#window(WindowDefinition...), then referenced windows will be inlined.

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