jOOQ 3.18.7 · org.jooq.WindowSpecification

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.

Method Summary

Modifier and Type	Method and Description
public @Nullable QOM.FrameExclude	$exclude() Experimental query object model accessor method, see also `QOM`.
public @Nullable Integer	$frameEnd() Experimental query object model accessor method, see also `QOM`.
public @Nullable Integer	$frameStart() Experimental query object model accessor method, see also `QOM`.
public @Nullable QOM.FrameUnits	$frameUnits() Experimental query object model accessor method, see also `QOM`.
public @NotNull QOM.UnmodifiableList<? extends SortField<?>>	$orderBy() Experimental query object model accessor method, see also `QOM`.
public @NotNull QOM.UnmodifiableList<? extends GroupField>	$partitionBy() Experimental query object model accessor method, see also `QOM`.
public @Nullable WindowDefinition	$windowDefinition() Deprecated as a consequence of `WindowDefinition` being deprecated. Experimental query object model accessor method, see also `QOM`.

Inherited from org.jooq.QueryPart:: equals hashCode toString

Method Detail

$exclude back to summary

$exclude	back to summary
public @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. Annotations @Experimental @Nullable

public @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.

Annotations

@Experimental
@Nullable

$frameEnd back to summary

$frameEnd	back to summary
public @Nullable Integer $frameEnd() Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Experimental @Nullable

public @Nullable Integer $frameEnd()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations

@Experimental
@Nullable

$frameStart back to summary

$frameStart	back to summary
public @Nullable Integer $frameStart() Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Experimental @Nullable

public @Nullable Integer $frameStart()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations

@Experimental
@Nullable

$frameUnits back to summary

$frameUnits	back to summary
public @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. Annotations @Experimental @Nullable

public @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.

Annotations

@Experimental
@Nullable

$orderBy back to summary

$orderBy	back to summary
public @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. Annotations @Experimental @NotNull

public @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.

Annotations

@Experimental
@NotNull

$partitionBy back to summary

$partitionBy	back to summary
public @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. Annotations @Experimental @NotNull

public @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.

Annotations

@Experimental
@NotNull

$windowDefinition back to summary

$windowDefinition	back to summary
public @Nullable WindowDefinition $windowDefinition() Deprecated as a consequence of `WindowDefinition` being deprecated. See corresponding docs for further information. Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Experimental @Nullable

public @Nullable WindowDefinition $windowDefinition()

Deprecated

as a consequence of WindowDefinition being deprecated. See corresponding docs for further information.

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations

@Experimental
@Nullable

public Interface WindowSpecification

Method Summary

Method Detail