- Type Parameters:
T
- The function return type
- All Superinterfaces:
WindowOverStep<T>
- All Known Subinterfaces:
WindowFromFirstLastStep<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 WindowOverStep<T>
Add anIGNORE NULLS
clause to the window function.@NotNull WindowOverStep<T>
Add aRESPECT NULLS
clause to the window function.
-
Method Details
-
ignoreNulls
@NotNull @Support({BIGQUERY,DB2,DUCKDB,EXASOL,H2,INFORMIX,ORACLE,REDSHIFT,SNOWFLAKE,SQLSERVER2022,SYBASE,TERADATA,TRINO,VERTICA}) @NotNull WindowOverStep<T> ignoreNulls()Add anIGNORE NULLS
clause to the window function. This might not be supported by all dialects. -
respectNulls
@NotNull @Support({BIGQUERY,DB2,DUCKDB,EXASOL,H2,INFORMIX,ORACLE,REDSHIFT,SNOWFLAKE,SQLSERVER2022,SYBASE,TERADATA,TRINO,VERTICA}) @NotNull WindowOverStep<T> respectNulls()Add aRESPECT NULLS
clause to the window function. This might not be supported by all dialects.
-