org.jooq

Interface WindowSpecificationRowsStep

All Superinterfaces:

QueryPart, 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();
 

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

• They're operating on mutable implementations (as of jOOQ 3.x)
• They're less composable and not easy to get right when dynamic SQL gets complex
• They're less readable
• They might have binary incompatible changes between minor releases

Author:

Lukas Eder

Method Summary

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={AURORA_POSTGRES,DB2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationFinalStep rowsUnboundedPreceding()

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

rowsPreceding

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

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

rowsCurrentRow

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

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

rowsUnboundedFollowing

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

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

rowsFollowing

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

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

rowsBetweenUnboundedPreceding

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

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

rowsBetweenPreceding

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

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

rowsBetweenCurrentRow

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

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

rowsBetweenUnboundedFollowing

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

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

rowsBetweenFollowing

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

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

rangeUnboundedPreceding

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

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

rangePreceding

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

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

rangeCurrentRow

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

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

rangeUnboundedFollowing

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

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

rangeFollowing

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

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

rangeBetweenUnboundedPreceding

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

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

rangeBetweenPreceding

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

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

rangeBetweenCurrentRow

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

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

rangeBetweenUnboundedFollowing

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

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

rangeBetweenFollowing

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

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