WindowRowsAndStep (jOOQ 3.11.12 API)

Type Parameters:: T - The function return type

public interface WindowRowsAndStep<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

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`WindowFinalStep<T>`	`andCurrentRow()` Add a `...`
`WindowFinalStep<T>`	`andFollowing(int number)` Add a `...`
`WindowFinalStep<T>`	`andPreceding(int number)` Add a `...`
`WindowFinalStep<T>`	`andUnboundedFollowing()` Add a `...`
`WindowFinalStep<T>`	`andUnboundedPreceding()` Add a `...`

Method Detail

andUnboundedPreceding

@Support(value={AURORA_POSTGRES,DB2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER2012,SYBASE,TERADATA})
WindowFinalStep<T> andUnboundedPreceding()

Add a ... AND UNBOUNDED PRECEDING frame clause to the window function.

andPreceding

@Support(value={AURORA_POSTGRES,DB2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER2012,SYBASE,TERADATA})
WindowFinalStep<T> andPreceding(int number)

Add a ... AND [number] PRECEDING frame clause to the window function.

andCurrentRow

@Support(value={AURORA_POSTGRES,DB2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER2012,SYBASE,TERADATA})
WindowFinalStep<T> andCurrentRow()

Add a ... AND CURRENT ROW frame clause to the window function.

andUnboundedFollowing

@Support(value={AURORA_POSTGRES,DB2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER2012,SYBASE,TERADATA})
WindowFinalStep<T> andUnboundedFollowing()

Add a ... AND UNBOUNDED FOLLOWING frame clause to the window function.

andFollowing

@Support(value={AURORA_POSTGRES,DB2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER2012,SYBASE,TERADATA})
WindowFinalStep<T> andFollowing(int number)

Add a ... AND [number] FOLLOWING frame clause to the window function.

Interface WindowRowsAndStep<T>