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 WindowIgnoreNullsStep

ignoreNulls, respectNulls

Methods inherited from interface WindowOverStep

over, over, over, over, over

Method Details

fromFirst

@NotNull
@Support({DB2,EXASOL,FIREBIRD_4_0,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,FIREBIRD_4_0,H2,ORACLE,SNOWFLAKE})
@NotNull WindowIgnoreNullsStep<T> fromLast()

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