WindowSpecificationRowsStep (jOOQ 3.10.8 API)

All Superinterfaces:

QueryPart, java.io.Serializable, WindowSpecification, WindowSpecificationFinalStep

All Known Subinterfaces:

WindowSpecificationOrderByStep, WindowSpecificationPartitionByStep
```
public interface WindowSpecificationRowsStep
extends WindowSpecificationFinalStep
```
An intermediate step in the construction of a WindowSpecification.
Example:
```
 WindowSpecification spec =
 DSL.partitionBy(BOOK.AUTHOR_ID)
    .orderBy(BOOK.ID)
    .rowsBetweenUnboundedPreceding()
    .andCurrentRow();
 
```
Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`WindowSpecificationRowsAndStep`	`rangeBetweenCurrentRow()` Add a `RANGE BETWEEN CURRENT ROW ...`
`WindowSpecificationRowsAndStep`	`rangeBetweenFollowing(int number)` Add a `RANGE BETWEEN [number] FOLLOWING ...`
`WindowSpecificationRowsAndStep`	`rangeBetweenPreceding(int number)` Add a `RANGE BETWEEN [number] PRECEDING ...`
`WindowSpecificationRowsAndStep`	`rangeBetweenUnboundedFollowing()` Add a `RANGE BETWEEN UNBOUNDED FOLLOWING ...`
`WindowSpecificationRowsAndStep`	`rangeBetweenUnboundedPreceding()` Add a `RANGE BETWEEN UNBOUNDED PRECEDING ...`
`WindowSpecificationFinalStep`	`rangeCurrentRow()` Add a `RANGE CURRENT ROW` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rangeFollowing(int number)` Add a `RANGE [number] FOLLOWING` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rangePreceding(int number)` Add a `RANGE [number] PRECEDING` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rangeUnboundedFollowing()` Add a `RANGE UNBOUNDED FOLLOWING` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rangeUnboundedPreceding()` Add a `RANGE UNBOUNDED PRECEDING` frame clause to the window specification.
`WindowSpecificationRowsAndStep`	`rowsBetweenCurrentRow()` Add a `ROWS BETWEEN CURRENT ROW ...`
`WindowSpecificationRowsAndStep`	`rowsBetweenFollowing(int number)` Add a `ROWS BETWEEN [number] FOLLOWING ...`
`WindowSpecificationRowsAndStep`	`rowsBetweenPreceding(int number)` Add a `ROWS BETWEEN [number] PRECEDING ...`
`WindowSpecificationRowsAndStep`	`rowsBetweenUnboundedFollowing()` Add a `ROWS BETWEEN UNBOUNDED FOLLOWING ...`
`WindowSpecificationRowsAndStep`	`rowsBetweenUnboundedPreceding()` Add a `ROWS BETWEEN UNBOUNDED PRECEDING ...`
`WindowSpecificationFinalStep`	`rowsCurrentRow()` Add a `ROWS CURRENT ROW` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rowsFollowing(int number)` Add a `ROWS [number] FOLLOWING` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rowsPreceding(int number)` Add a `ROWS [number] PRECEDING` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rowsUnboundedFollowing()` Add a `ROWS UNBOUNDED FOLLOWING` frame clause to the window specification.
`WindowSpecificationFinalStep`	`rowsUnboundedPreceding()` Add a `ROWS UNBOUNDED PRECEDING` frame clause to the window specification.

Methods inherited from interface org.jooq.QueryPart
equals, hashCode, toString

Method Detail

rowsUnboundedPreceding

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

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

rowsPreceding

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

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

rowsCurrentRow

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

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

rowsUnboundedFollowing

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

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

rowsFollowing

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

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

rowsBetweenUnboundedPreceding

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

Add a ROWS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.

rowsBetweenPreceding

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

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

rowsBetweenCurrentRow

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

Add a ROWS BETWEEN CURRENT ROW ... frame clause to the window specification.

rowsBetweenUnboundedFollowing

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

Add a ROWS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.

rowsBetweenFollowing

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

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

rangeUnboundedPreceding

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

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

rangePreceding

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

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

rangeCurrentRow

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

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

rangeUnboundedFollowing

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

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

rangeFollowing

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

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

rangeBetweenUnboundedPreceding

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenUnboundedPreceding()

Add a RANGE BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.

rangeBetweenPreceding

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenPreceding(int number)

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

rangeBetweenCurrentRow

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenCurrentRow()

Add a RANGE BETWEEN CURRENT ROW ... frame clause to the window specification.

rangeBetweenUnboundedFollowing

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenUnboundedFollowing()

Add a RANGE BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.

rangeBetweenFollowing

@Support(value={DB2,INFORMIX,MYSQL_8_0,POSTGRES,ORACLE,SQLSERVER2012,SYBASE,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenFollowing(int number)

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

Interface WindowSpecificationRowsStep