Interface WindowIgnoreNullsStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

WindowOverStep<T>

All Known Subinterfaces:

WindowFromFirstLastStep<T>

public interface WindowIgnoreNullsStep<T>
extends 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()

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull WindowOverStep<T>	ignoreNulls()	Add an IGNORE NULLS clause to the window function.
@NotNull WindowOverStep<T>	respectNulls()	Add a RESPECT NULLS clause to the window function.

Methods inherited from interface WindowOverStep

over, over, over, over, over

Method Details

ignoreNulls

@NotNull
@Support({BIGQUERY,DATABRICKS,DB2,DUCKDB,EXASOL,H2,INFORMIX,ORACLE,REDSHIFT,SNOWFLAKE,SQLSERVER2022,SYBASE,TERADATA,TRINO,VERTICA})
@NotNull WindowOverStep<T> ignoreNulls()

Add an IGNORE NULLS clause to the window function. This might not be supported by all dialects.

respectNulls

@NotNull
@Support({BIGQUERY,DATABRICKS,DB2,DUCKDB,EXASOL,H2,INFORMIX,ORACLE,REDSHIFT,SNOWFLAKE,SQLSERVER2022,SYBASE,TERADATA,TRINO,VERTICA})
@NotNull WindowOverStep<T> respectNulls()

Add a RESPECT NULLS clause to the window function. This might not be supported by all dialects.