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	Description
`WindowExcludeStep<T>`	`andCurrentRow()`	Add a `...`
`WindowExcludeStep<T>`	`andFollowing(int number)`	Add a `...`
`WindowExcludeStep<T>`	`andPreceding(int number)`	Add a `...`
`WindowExcludeStep<T>`	`andUnboundedFollowing()`	Add a `...`
`WindowExcludeStep<T>`	`andUnboundedPreceding()`	Add a `...`

Method Detail

andUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> andUnboundedPreceding()

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

andPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> andPreceding(int number)

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

andCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> andCurrentRow()

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

andUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> andUnboundedFollowing()

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

andFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> andFollowing(int number)

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