Module org.jooq

Package org.jooq

Interface WindowSpecificationRowsStep

All Superinterfaces:

QueryPart, Serializable, WindowSpecification, WindowSpecificationFinalStep

All Known Subinterfaces:

WindowDefinition, 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	Description
WindowSpecificationRowsAndStep	groupsBetweenCurrentRow()	Add a GROUPS BETWEEN CURRENT ROW ... frame clause to the window specification.
WindowSpecificationRowsAndStep	groupsBetweenFollowing(int number)	Add a GROUPS BETWEEN [number] FOLLOWING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	groupsBetweenPreceding(int number)	Add a GROUPS BETWEEN [number] PRECEDING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	groupsBetweenUnboundedFollowing()	Add a GROUPS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	groupsBetweenUnboundedPreceding()	Add a GROUPS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.
WindowSpecificationExcludeStep	groupsCurrentRow()	Add a GROUPS CURRENT ROW frame clause to the window specification.
WindowSpecificationExcludeStep	groupsFollowing(int number)	Add a GROUPS [number] FOLLOWING frame clause to the window specification.
WindowSpecificationExcludeStep	groupsPreceding(int number)	Add a GROUPS [number] PRECEDING frame clause to the window specification.
WindowSpecificationExcludeStep	groupsUnboundedFollowing()	Add a GROUPS UNBOUNDED FOLLOWING frame clause to the window specification.
WindowSpecificationExcludeStep	groupsUnboundedPreceding()	Add a GROUPS UNBOUNDED PRECEDING frame clause to the window specification.
WindowSpecificationRowsAndStep	rangeBetweenCurrentRow()	Add a RANGE BETWEEN CURRENT ROW ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rangeBetweenFollowing(int number)	Add a RANGE BETWEEN [number] FOLLOWING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rangeBetweenPreceding(int number)	Add a RANGE BETWEEN [number] PRECEDING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rangeBetweenUnboundedFollowing()	Add a RANGE BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rangeBetweenUnboundedPreceding()	Add a RANGE BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.
WindowSpecificationExcludeStep	rangeCurrentRow()	Add a RANGE CURRENT ROW frame clause to the window specification.
WindowSpecificationExcludeStep	rangeFollowing(int number)	Add a RANGE [number] FOLLOWING frame clause to the window specification.
WindowSpecificationExcludeStep	rangePreceding(int number)	Add a RANGE [number] PRECEDING frame clause to the window specification.
WindowSpecificationExcludeStep	rangeUnboundedFollowing()	Add a RANGE UNBOUNDED FOLLOWING frame clause to the window specification.
WindowSpecificationExcludeStep	rangeUnboundedPreceding()	Add a RANGE UNBOUNDED PRECEDING frame clause to the window specification.
WindowSpecificationRowsAndStep	rowsBetweenCurrentRow()	Add a ROWS BETWEEN CURRENT ROW ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rowsBetweenFollowing(int number)	Add a ROWS BETWEEN [number] FOLLOWING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rowsBetweenPreceding(int number)	Add a ROWS BETWEEN [number] PRECEDING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rowsBetweenUnboundedFollowing()	Add a ROWS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.
WindowSpecificationRowsAndStep	rowsBetweenUnboundedPreceding()	Add a ROWS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.
WindowSpecificationExcludeStep	rowsCurrentRow()	Add a ROWS CURRENT ROW frame clause to the window specification.
WindowSpecificationExcludeStep	rowsFollowing(int number)	Add a ROWS [number] FOLLOWING frame clause to the window specification.
WindowSpecificationExcludeStep	rowsPreceding(int number)	Add a ROWS [number] PRECEDING frame clause to the window specification.
WindowSpecificationExcludeStep	rowsUnboundedFollowing()	Add a ROWS UNBOUNDED FOLLOWING frame clause to the window specification.
WindowSpecificationExcludeStep	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({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rowsUnboundedPreceding()

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

rowsPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rowsPreceding(int number)

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

rowsCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rowsCurrentRow()

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

rowsUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rowsUnboundedFollowing()

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

rowsFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rowsFollowing(int number)

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

rowsBetweenUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenUnboundedPreceding()

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

rowsBetweenPreceding

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

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

rowsBetweenCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenCurrentRow()

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

rowsBetweenUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rowsBetweenUnboundedFollowing()

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

rowsBetweenFollowing

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

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

rangeUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rangeUnboundedPreceding()

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

rangePreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rangePreceding(int number)

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

rangeCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rangeCurrentRow()

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

rangeUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rangeUnboundedFollowing()

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

rangeFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationExcludeStep rangeFollowing(int number)

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

rangeBetweenUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenUnboundedPreceding()

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

rangeBetweenPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenPreceding(int number)

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

rangeBetweenCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenCurrentRow()

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

rangeBetweenUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenUnboundedFollowing()

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

rangeBetweenFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowSpecificationRowsAndStep rangeBetweenFollowing(int number)

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

groupsUnboundedPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationExcludeStep groupsUnboundedPreceding()

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

groupsPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationExcludeStep groupsPreceding(int number)

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

groupsCurrentRow

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationExcludeStep groupsCurrentRow()

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

groupsUnboundedFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationExcludeStep groupsUnboundedFollowing()

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

groupsFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationExcludeStep groupsFollowing(int number)

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

groupsBetweenUnboundedPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationRowsAndStep groupsBetweenUnboundedPreceding()

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

groupsBetweenPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationRowsAndStep groupsBetweenPreceding(int number)

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

groupsBetweenCurrentRow

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationRowsAndStep groupsBetweenCurrentRow()

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

groupsBetweenUnboundedFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationRowsAndStep groupsBetweenUnboundedFollowing()

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

groupsBetweenFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowSpecificationRowsAndStep groupsBetweenFollowing(int number)

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