Module org.jooq

Package org.jooq

Interface WindowOverStep<T>

Type Parameters:

T - The function return type

All Known Subinterfaces:

AggregateFilterStep<T>, AggregateFunction<T>, ArrayAggOrderByStep<T>, GroupConcatOrderByStep, GroupConcatSeparatorStep, JSONArrayAggNullStep<T>, JSONArrayAggOrderByStep<J>, JSONArrayAggReturningStep<T>, JSONObjectAggNullStep<T>, JSONObjectAggReturningStep<T>, OptionallyOrderedAggregateFunction<T>, QOM.AnyValue<T>, QOM.ArrayAgg<T>, QOM.Avg, QOM.BitAndAgg<T>, QOM.BitNandAgg<T>, QOM.BitNorAgg<T>, QOM.BitOrAgg<T>, QOM.BitXNorAgg<T>, QOM.BitXorAgg<T>, QOM.BoolAnd, QOM.BoolOr, QOM.Collect<T,A>, QOM.Corr, QOM.Count, QOM.CountTable, QOM.CovarPop, QOM.CovarSamp, QOM.JSONArrayAgg<J>, QOM.JSONObjectAgg<J>, QOM.Max<T>, QOM.MaxBy<T>, QOM.Median, QOM.Min<T>, QOM.MinBy<T>, QOM.Mode<T>, QOM.MultisetAgg<R>, QOM.Product, QOM.RatioToReport, QOM.RegrAvgX, QOM.RegrAvgY, QOM.RegrCount, QOM.RegrIntercept, QOM.RegrR2, QOM.RegrSlope, QOM.RegrSxx, QOM.RegrSxy, QOM.RegrSyy, QOM.StddevPop, QOM.StddevSamp, QOM.Sum, QOM.VarPop, QOM.VarSamp, QOM.XMLAgg, WindowBeforeOverStep<T>, WindowFromFirstLastStep<T>, WindowIgnoreNullsStep<T>, XMLAggOrderByStep<T>

public interface WindowOverStep<T>

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 Type	Method	Description
@NotNull WindowPartitionByStep<T>	over()	Turn this aggregate function into a window function.
@NotNull WindowFinalStep<T>	over(String name)	Turn this aggregate function into a window function referencing a window name.
@NotNull WindowFinalStep<T>	over(Name name)	Turn this aggregate function into a window function referencing a window name.
@NotNull WindowFinalStep<T>	over(WindowDefinition definition)	Turn this aggregate function into a window function referencing a window definition.
@NotNull WindowFinalStep<T>	over(WindowSpecification specification)	Turn this aggregate function into a window function.

Method Details

over

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowPartitionByStep<T> over()

Turn this aggregate function into a window function.

An example:

 MAX(id) OVER (PARTITION BY 1)
 

over

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowFinalStep<T> over(Name name)

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.

over

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowFinalStep<T> over(String name)

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.

over

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowFinalStep<T> over(WindowSpecification specification)

Turn this aggregate function into a window function.

An example:

 MAX(id) OVER (PARTITION BY 1)
 

over

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowFinalStep<T> over(WindowDefinition definition)

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.