Module org.jooq

Package org.jooq

Interface WindowRowsAndStep<T>

Type Parameters:

T - The function return type

public interface WindowRowsAndStep<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()
 

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull WindowExcludeStep<T>	andCurrentRow()	Add a … AND CURRENT ROW frame clause to the window function.
@NotNull WindowExcludeStep<T>	andFollowing(int number)	Add a … AND [number] FOLLOWING frame clause to the window function.
@NotNull WindowExcludeStep<T>	andPreceding(int number)	Add a … AND [number] PRECEDING frame clause to the window function.
@NotNull WindowExcludeStep<T>	andUnboundedFollowing()	Add a … AND UNBOUNDED FOLLOWING frame clause to the window function.
@NotNull WindowExcludeStep<T>	andUnboundedPreceding()	Add a … AND UNBOUNDED PRECEDING frame clause to the window function.

Method Details

andUnboundedPreceding

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_4_0,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowExcludeStep<T> andUnboundedPreceding()

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

andPreceding

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_4_0,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowExcludeStep<T> andPreceding(int number)

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

andCurrentRow

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_4_0,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowExcludeStep<T> andCurrentRow()

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

andUnboundedFollowing

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_4_0,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowExcludeStep<T> andUnboundedFollowing()

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

andFollowing

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_4_0,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowExcludeStep<T> andFollowing(int number)

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