- All Superinterfaces:
QueryPart
,Serializable
,WindowSpecification
,WindowSpecificationFinalStep
An intermediate step in the construction of a Referencing
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 TypeMethodDescription@NotNull WindowSpecificationFinalStep
Add anEXCLUDE CURRENT ROW
clause.@NotNull WindowSpecificationFinalStep
Add anEXCLUDE GROUP
clause.@NotNull WindowSpecificationFinalStep
Add anEXCLUDE NO OTHERS
clause.@NotNull WindowSpecificationFinalStep
Add anEXCLUDE TIES
clause.Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, equals, hashCode, toString
Methods inherited from interface org.jooq.WindowSpecification
$exclude, $frameEnd, $frameStart, $frameUnits, $orderBy, $partitionBy, $windowDefinition
-
Method Details
-
excludeCurrentRow
@NotNull @Support({COCKROACHDB,DUCKDB,EXASOL,H2,ORACLE20C,POSTGRES_11,SQLITE_3_28,TRINO,YUGABYTEDB}) @NotNull WindowSpecificationFinalStep excludeCurrentRow()Add anEXCLUDE CURRENT ROW
clause. -
excludeGroup
@NotNull @Support({COCKROACHDB,DUCKDB,EXASOL,H2,ORACLE20C,POSTGRES_11,SQLITE_3_28,TRINO,YUGABYTEDB}) @NotNull WindowSpecificationFinalStep excludeGroup()Add anEXCLUDE GROUP
clause. -
excludeTies
@NotNull @Support({COCKROACHDB,DUCKDB,EXASOL,H2,ORACLE20C,POSTGRES_11,SQLITE_3_28,TRINO,YUGABYTEDB}) @NotNull WindowSpecificationFinalStep excludeTies()Add anEXCLUDE TIES
clause. -
excludeNoOthers
@NotNull @Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,FIREBIRD_4_0,H2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA,YUGABYTEDB}) @NotNull WindowSpecificationFinalStep excludeNoOthers()Add anEXCLUDE NO OTHERS
clause.
-