Module org.jooq

Package org.jooq

Interface WindowFromFirstLastStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

WindowIgnoreNullsStep<T>, WindowOverStep<T>

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

Methods inherited from interface org.jooq.WindowIgnoreNullsStep

ignoreNulls, respectNulls

Methods inherited from interface org.jooq.WindowOverStep

over, over, over, over, over

Method Details

fromFirst

@NotNull
@Support({DB2,EXASOL,H2,ORACLE,SNOWFLAKE})
@NotNull WindowIgnoreNullsStep<T> fromFirst()

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

fromLast

@NotNull
@Support({DB2,EXASOL,H2,ORACLE,SNOWFLAKE})
@NotNull WindowIgnoreNullsStep<T> fromLast()

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