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
@NotNull WindowSpecificationRowsAndStep	groupsBetweenCurrentRow()	Add a GROUPS BETWEEN CURRENT ROW ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	groupsBetweenFollowing(int number)	Add a GROUPS BETWEEN [number] FOLLOWING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	groupsBetweenPreceding(int number)	Add a GROUPS BETWEEN [number] PRECEDING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	groupsBetweenUnboundedFollowing()	Add a GROUPS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	groupsBetweenUnboundedPreceding()	Add a GROUPS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	groupsCurrentRow()	Add a GROUPS CURRENT ROW frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	groupsFollowing(int number)	Add a GROUPS [number] FOLLOWING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	groupsPreceding(int number)	Add a GROUPS [number] PRECEDING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	groupsUnboundedFollowing()	Add a GROUPS UNBOUNDED FOLLOWING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	groupsUnboundedPreceding()	Add a GROUPS UNBOUNDED PRECEDING frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rangeBetweenCurrentRow()	Add a RANGE BETWEEN CURRENT ROW ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rangeBetweenFollowing(int number)	Add a RANGE BETWEEN [number] FOLLOWING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rangeBetweenPreceding(int number)	Add a RANGE BETWEEN [number] PRECEDING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rangeBetweenUnboundedFollowing()	Add a RANGE BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rangeBetweenUnboundedPreceding()	Add a RANGE BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rangeCurrentRow()	Add a RANGE CURRENT ROW frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rangeFollowing(int number)	Add a RANGE [number] FOLLOWING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rangePreceding(int number)	Add a RANGE [number] PRECEDING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rangeUnboundedFollowing()	Add a RANGE UNBOUNDED FOLLOWING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rangeUnboundedPreceding()	Add a RANGE UNBOUNDED PRECEDING frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rowsBetweenCurrentRow()	Add a ROWS BETWEEN CURRENT ROW ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rowsBetweenFollowing(int number)	Add a ROWS BETWEEN [number] FOLLOWING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rowsBetweenPreceding(int number)	Add a ROWS BETWEEN [number] PRECEDING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rowsBetweenUnboundedFollowing()	Add a ROWS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window specification.
@NotNull WindowSpecificationRowsAndStep	rowsBetweenUnboundedPreceding()	Add a ROWS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rowsCurrentRow()	Add a ROWS CURRENT ROW frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rowsFollowing(int number)	Add a ROWS [number] FOLLOWING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rowsPreceding(int number)	Add a ROWS [number] PRECEDING frame clause to the window specification.
@NotNull WindowSpecificationExcludeStep	rowsUnboundedFollowing()	Add a ROWS UNBOUNDED FOLLOWING frame clause to the window specification.
@NotNull 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

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

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

rowsPreceding

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

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

rowsCurrentRow

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

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

rowsUnboundedFollowing

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

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

rowsFollowing

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

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

rowsBetweenUnboundedPreceding

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

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

rowsBetweenPreceding

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

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

rowsBetweenCurrentRow

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

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

rowsBetweenUnboundedFollowing

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

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

rowsBetweenFollowing

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

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

rangeUnboundedPreceding

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

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

rangePreceding

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

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

rangeCurrentRow

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

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

rangeUnboundedFollowing

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

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

rangeFollowing

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

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

rangeBetweenUnboundedPreceding

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

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

rangeBetweenPreceding

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

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

rangeBetweenCurrentRow

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

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

rangeBetweenUnboundedFollowing

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

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

rangeBetweenFollowing

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

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

groupsUnboundedPreceding

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

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

groupsPreceding

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

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

groupsCurrentRow

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

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

groupsUnboundedFollowing

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

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

groupsFollowing

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

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

groupsBetweenUnboundedPreceding

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

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

groupsBetweenPreceding

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

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

groupsBetweenCurrentRow

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

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

groupsBetweenUnboundedFollowing

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

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

groupsBetweenFollowing

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

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