-
- All Superinterfaces:
QueryPart
,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 theOVER
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 inDSL
.- Author:
- Lukas Eder