-
- All Superinterfaces:
QueryPart
,Serializable
,WindowSpecification
,WindowSpecificationFinalStep
- All Known Subinterfaces:
WindowDefinition
,WindowSpecificationOrderByStep
,WindowSpecificationPartitionByStep
public interface WindowSpecificationRowsStep extends WindowSpecificationFinalStep
An intermediate step in the construction of aWindowSpecification
.Example:
WindowSpecification spec = DSL.partitionBy(BOOK.AUTHOR_ID) .orderBy(BOOK.ID) .rowsBetweenUnboundedPreceding() .andCurrentRow();
Referencing
XYZ*Step
types directly from client codeIt 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
All Methods Instance Methods Abstract Methods Modifier and Type Method Description WindowSpecificationRowsAndStep
groupsBetweenCurrentRow()
Add aGROUPS BETWEEN CURRENT ROW ...
frame clause to the window specification.WindowSpecificationRowsAndStep
groupsBetweenFollowing(int number)
Add aGROUPS BETWEEN [number] FOLLOWING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
groupsBetweenPreceding(int number)
Add aGROUPS BETWEEN [number] PRECEDING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
groupsBetweenUnboundedFollowing()
Add aGROUPS BETWEEN UNBOUNDED FOLLOWING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
groupsBetweenUnboundedPreceding()
Add aGROUPS BETWEEN UNBOUNDED PRECEDING ...
frame clause to the window specification.WindowSpecificationExcludeStep
groupsCurrentRow()
Add aGROUPS CURRENT ROW
frame clause to the window specification.WindowSpecificationExcludeStep
groupsFollowing(int number)
Add aGROUPS [number] FOLLOWING
frame clause to the window specification.WindowSpecificationExcludeStep
groupsPreceding(int number)
Add aGROUPS [number] PRECEDING
frame clause to the window specification.WindowSpecificationExcludeStep
groupsUnboundedFollowing()
Add aGROUPS UNBOUNDED FOLLOWING
frame clause to the window specification.WindowSpecificationExcludeStep
groupsUnboundedPreceding()
Add aGROUPS UNBOUNDED PRECEDING
frame clause to the window specification.WindowSpecificationRowsAndStep
rangeBetweenCurrentRow()
Add aRANGE BETWEEN CURRENT ROW ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rangeBetweenFollowing(int number)
Add aRANGE BETWEEN [number] FOLLOWING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rangeBetweenPreceding(int number)
Add aRANGE BETWEEN [number] PRECEDING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rangeBetweenUnboundedFollowing()
Add aRANGE BETWEEN UNBOUNDED FOLLOWING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rangeBetweenUnboundedPreceding()
Add aRANGE BETWEEN UNBOUNDED PRECEDING ...
frame clause to the window specification.WindowSpecificationExcludeStep
rangeCurrentRow()
Add aRANGE CURRENT ROW
frame clause to the window specification.WindowSpecificationExcludeStep
rangeFollowing(int number)
Add aRANGE [number] FOLLOWING
frame clause to the window specification.WindowSpecificationExcludeStep
rangePreceding(int number)
Add aRANGE [number] PRECEDING
frame clause to the window specification.WindowSpecificationExcludeStep
rangeUnboundedFollowing()
Add aRANGE UNBOUNDED FOLLOWING
frame clause to the window specification.WindowSpecificationExcludeStep
rangeUnboundedPreceding()
Add aRANGE UNBOUNDED PRECEDING
frame clause to the window specification.WindowSpecificationRowsAndStep
rowsBetweenCurrentRow()
Add aROWS BETWEEN CURRENT ROW ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rowsBetweenFollowing(int number)
Add aROWS BETWEEN [number] FOLLOWING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rowsBetweenPreceding(int number)
Add aROWS BETWEEN [number] PRECEDING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rowsBetweenUnboundedFollowing()
Add aROWS BETWEEN UNBOUNDED FOLLOWING ...
frame clause to the window specification.WindowSpecificationRowsAndStep
rowsBetweenUnboundedPreceding()
Add aROWS BETWEEN UNBOUNDED PRECEDING ...
frame clause to the window specification.WindowSpecificationExcludeStep
rowsCurrentRow()
Add aROWS CURRENT ROW
frame clause to the window specification.WindowSpecificationExcludeStep
rowsFollowing(int number)
Add aROWS [number] FOLLOWING
frame clause to the window specification.WindowSpecificationExcludeStep
rowsPreceding(int number)
Add aROWS [number] PRECEDING
frame clause to the window specification.WindowSpecificationExcludeStep
rowsUnboundedFollowing()
Add aROWS UNBOUNDED FOLLOWING
frame clause to the window specification.WindowSpecificationExcludeStep
rowsUnboundedPreceding()
Add aROWS UNBOUNDED PRECEDING
frame clause to the window specification.
-
-
-
Method Detail
-
rowsUnboundedPreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rowsUnboundedPreceding()
Add aROWS UNBOUNDED PRECEDING
frame clause to the window specification.
-
rowsPreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rowsPreceding(int number)
Add aROWS [number] PRECEDING
frame clause to the window specification.
-
rowsCurrentRow
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rowsCurrentRow()
Add aROWS CURRENT ROW
frame clause to the window specification.
-
rowsUnboundedFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rowsUnboundedFollowing()
Add aROWS UNBOUNDED FOLLOWING
frame clause to the window specification.
-
rowsFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rowsFollowing(int number)
Add aROWS [number] FOLLOWING
frame clause to the window specification.
-
rowsBetweenUnboundedPreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rowsBetweenUnboundedPreceding()
Add aROWS BETWEEN UNBOUNDED PRECEDING ...
frame clause to the window specification.
-
rowsBetweenPreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rowsBetweenPreceding(int number)
Add aROWS BETWEEN [number] PRECEDING ...
frame clause to the window specification.
-
rowsBetweenCurrentRow
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rowsBetweenCurrentRow()
Add aROWS BETWEEN CURRENT ROW ...
frame clause to the window specification.
-
rowsBetweenUnboundedFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rowsBetweenUnboundedFollowing()
Add aROWS BETWEEN UNBOUNDED FOLLOWING ...
frame clause to the window specification.
-
rowsBetweenFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rowsBetweenFollowing(int number)
Add aROWS BETWEEN [number] FOLLOWING ...
frame clause to the window specification.
-
rangeUnboundedPreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rangeUnboundedPreceding()
Add aRANGE UNBOUNDED PRECEDING
frame clause to the window specification.
-
rangePreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rangePreceding(int number)
Add aRANGE [number] PRECEDING
frame clause to the window specification.
-
rangeCurrentRow
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rangeCurrentRow()
Add aRANGE CURRENT ROW
frame clause to the window specification.
-
rangeUnboundedFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rangeUnboundedFollowing()
Add aRANGE UNBOUNDED FOLLOWING
frame clause to the window specification.
-
rangeFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationExcludeStep rangeFollowing(int number)
Add aRANGE [number] FOLLOWING
frame clause to the window specification.
-
rangeBetweenUnboundedPreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rangeBetweenUnboundedPreceding()
Add aRANGE BETWEEN UNBOUNDED PRECEDING ...
frame clause to the window specification.
-
rangeBetweenPreceding
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rangeBetweenPreceding(int number)
Add aRANGE BETWEEN [number] PRECEDING ...
frame clause to the window specification.
-
rangeBetweenCurrentRow
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rangeBetweenCurrentRow()
Add aRANGE BETWEEN CURRENT ROW ...
frame clause to the window specification.
-
rangeBetweenUnboundedFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rangeBetweenUnboundedFollowing()
Add aRANGE BETWEEN UNBOUNDED FOLLOWING ...
frame clause to the window specification.
-
rangeBetweenFollowing
@Support({AURORA_POSTGRES,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA}) WindowSpecificationRowsAndStep rangeBetweenFollowing(int number)
Add aRANGE BETWEEN [number] FOLLOWING ...
frame clause to the window specification.
-
groupsUnboundedPreceding
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationExcludeStep groupsUnboundedPreceding()
Add aGROUPS UNBOUNDED PRECEDING
frame clause to the window specification.
-
groupsPreceding
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationExcludeStep groupsPreceding(int number)
Add aGROUPS [number] PRECEDING
frame clause to the window specification.
-
groupsCurrentRow
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationExcludeStep groupsCurrentRow()
Add aGROUPS CURRENT ROW
frame clause to the window specification.
-
groupsUnboundedFollowing
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationExcludeStep groupsUnboundedFollowing()
Add aGROUPS UNBOUNDED FOLLOWING
frame clause to the window specification.
-
groupsFollowing
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationExcludeStep groupsFollowing(int number)
Add aGROUPS [number] FOLLOWING
frame clause to the window specification.
-
groupsBetweenUnboundedPreceding
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationRowsAndStep groupsBetweenUnboundedPreceding()
Add aGROUPS BETWEEN UNBOUNDED PRECEDING ...
frame clause to the window specification.
-
groupsBetweenPreceding
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationRowsAndStep groupsBetweenPreceding(int number)
Add aGROUPS BETWEEN [number] PRECEDING ...
frame clause to the window specification.
-
groupsBetweenCurrentRow
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationRowsAndStep groupsBetweenCurrentRow()
Add aGROUPS BETWEEN CURRENT ROW ...
frame clause to the window specification.
-
groupsBetweenUnboundedFollowing
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationRowsAndStep groupsBetweenUnboundedFollowing()
Add aGROUPS BETWEEN UNBOUNDED FOLLOWING ...
frame clause to the window specification.
-
groupsBetweenFollowing
@Support({H2,POSTGRES_11,SQLITE_3_28}) WindowSpecificationRowsAndStep groupsBetweenFollowing(int number)
Add aGROUPS BETWEEN [number] FOLLOWING ...
frame clause to the window specification.
-
-