org.jooq

Interface WindowIgnoreNullsStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

WindowOverStep<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 and Description
WindowOverStep<T>	ignoreNulls() Add an IGNORE NULLS clause to the window function.
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 Detail

ignoreNulls

@Support(value={DB2,INFORMIX,ORACLE,REDSHIFT,SYBASE})
WindowOverStep<T> ignoreNulls()

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

respectNulls

@Support(value={DB2,INFORMIX,ORACLE,REDSHIFT,SYBASE})
WindowOverStep<T> respectNulls()

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