WindowSpecification (jOOQ 3.12.1 API)

All Superinterfaces:

QueryPart, java.io.Serializable

All Known Subinterfaces:

WindowDefinition, WindowSpecificationExcludeStep, WindowSpecificationFinalStep, WindowSpecificationOrderByStep, WindowSpecificationPartitionByStep, WindowSpecificationRowsStep
```
public interface WindowSpecification
extends QueryPart
```
A window specification.
Window specifications are the syntactic clauses that can be passed to both window definitions in WINDOW clauses, as well as to the OVER clause of window functions. This makes window specifications highly reusable across several queries.
Example:
```
 WindowSpecification spec =
 DSL.partitionBy(BOOK.AUTHOR_ID)
    .orderBy(BOOK.ID)
    .rowsBetweenUnboundedPreceding()
    .andCurrentRow();
 
```
Instances can be created using DSL.partitionBy(Field...), DSL.orderBy(OrderField...), and overloads as well as rows / range / groups related methods in DSL.
Author:

Lukas Eder

- Method Summary
  - Methods inherited from interface org.jooq.QueryPart
    equals, hashCode, toString