- 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 TypeMethodDescription@NotNull WindowExcludeStep<T>
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>
Add a… AND UNBOUNDED FOLLOWING
frame clause to the window function.@NotNull WindowExcludeStep<T>
Add a… AND UNBOUNDED PRECEDING
frame clause to the window function.
-
Method Details
-
andUnboundedPreceding
@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,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,COCKROACHDB,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,COCKROACHDB,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,COCKROACHDB,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,COCKROACHDB,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.
-