WindowSpecificationRowsAndStep (jOOQ 3.10.8 API)

public interface WindowSpecificationRowsAndStep

An intermediate step in the construction of a WindowSpecification.

Example:

 WindowSpecification spec =
 DSL.partitionBy(BOOK.AUTHOR_ID)
    .orderBy(BOOK.ID)
    .rowsBetweenUnboundedPreceding()
    .andCurrentRow();

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

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep andUnboundedPreceding()

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

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep andPreceding(int number)

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

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep andCurrentRow()

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

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep andUnboundedFollowing()

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

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationFinalStep andFollowing(int number)

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

Interface WindowSpecificationRowsAndStep