org.jooq

public Interface WindowFromFirstLastStep<T>

Known Direct Implementers

extends WindowIgnoreNullsStep<T>org.jooq.impl.AbstractWindowFunction

Type Parameters

<T>: The function return type

Static Imports

org.jooq.SQLDialect.FIREBIRD, .SQLDialect.H2

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 WindowIgnoreNullsStep<T>	fromFirst() Add an `FROM FIRST` clause to the window function.
public @NotNull WindowIgnoreNullsStep<T>	fromLast() Add a `FROM LAST` clause to the window function.

Inherited from org.jooq.WindowIgnoreNullsStep:: ignoreNulls respectNulls

Method Detail

fromFirst back to summary

fromFirst	back to summary
public @NotNull WindowIgnoreNullsStep<T> fromFirst() Add an `FROM FIRST` clause to the window function. This might not be supported by all dialects. Annotations @NotNull @Support:FIREBIRD, H2

public @NotNull WindowIgnoreNullsStep<T> fromFirst()

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

Annotations

@NotNull
@Support:FIREBIRD, H2

fromLast back to summary

fromLast	back to summary
public @NotNull WindowIgnoreNullsStep<T> fromLast() Add a `FROM LAST` clause to the window function. This might not be supported by all dialects. Annotations @NotNull @Support:FIREBIRD, H2

public @NotNull WindowIgnoreNullsStep<T> fromLast()

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

Annotations

@NotNull
@Support:FIREBIRD, H2