Module org.jooq

Package org.jooq

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 org.jooq.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.