org.jooq

public Interface WindowIgnoreNullsStep<T>

Known Direct Subinterfaces

extends WindowOverStep<T>org.jooq.WindowFromFirstLastStep

Type Parameters

<T>: The function return type

Imports

org.jetbrains.annotations.*

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
public @NotNull WindowOverStep<T>	ignoreNulls() Add an `IGNORE NULLS` clause to the window function.
public @NotNull WindowOverStep<T>	respectNulls() Add a `RESPECT NULLS` clause to the window function.

Inherited from org.jooq.WindowOverStep:: over over over over over

Method Detail

ignoreNulls back to summary

ignoreNulls	back to summary
public @NotNull WindowOverStep<T> ignoreNulls() Add an `IGNORE NULLS` clause to the window function. This might not be supported by all dialects. Annotations @NotNull @Support:H2

public @NotNull WindowOverStep<T> ignoreNulls()

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

Annotations

@NotNull
@Support:H2

respectNulls back to summary

respectNulls	back to summary
public @NotNull WindowOverStep<T> respectNulls() Add a `RESPECT NULLS` clause to the window function. This might not be supported by all dialects. Annotations @NotNull @Support:H2

public @NotNull WindowOverStep<T> respectNulls()

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

Annotations

@NotNull
@Support:H2