- Type Parameters:
T
- The function return type
- All Superinterfaces:
WindowIgnoreNullsStep<T>
,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 TypeMethodDescription@NotNull WindowIgnoreNullsStep<T>
Add anFROM FIRST
clause to the window function.@NotNull WindowIgnoreNullsStep<T>
fromLast()
Add aFROM LAST
clause to the window function.Methods inherited from interface org.jooq.WindowIgnoreNullsStep
ignoreNulls, respectNulls
-
Method Details
-
fromFirst
@NotNull @Support({DB2,EXASOL,FIREBIRD_4_0,H2,ORACLE,SNOWFLAKE}) @NotNull WindowIgnoreNullsStep<T> fromFirst()Add anFROM 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 aFROM LAST
clause to the window function. This might not be supported by all dialects.
-