Module org.jooq
Package org.jooq

Interface WindowSpecification

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 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(GroupField...), DSL.orderBy(OrderField...), and overloads as well as rows / range / groups related methods in DSL.

Author:
Lukas Eder
  • Method Details Link icon

    • $windowDefinition Link icon

      @Experimental @Nullable @Nullable WindowDefinition $windowDefinition()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $partitionBy Link icon

      @Experimental @NotNull @NotNull QOM.UnmodifiableList<? extends GroupField> $partitionBy()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $orderBy Link icon

      @Experimental @NotNull @NotNull QOM.UnmodifiableList<? extends SortField<?>> $orderBy()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $frameUnits Link icon

      @Experimental @Nullable @Nullable QOM.FrameUnits $frameUnits()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $frameStart Link icon

      @Experimental @Nullable @Nullable Integer $frameStart()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $frameEnd Link icon

      @Experimental @Nullable @Nullable Integer $frameEnd()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $exclude Link icon

      @Experimental @Nullable @Nullable QOM.FrameExclude $exclude()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.