jOOQ 3.18.7 · org.jooq.impl.WindowSpecificationImpl

Modifier and Type	Field and Description
private QOM.FrameExclude	exclude
private Integer	frameEnd
private Integer	frameStart
private QOM.FrameUnits	frameUnits
private static final Set<SQLDialect>	OMIT_PARTITION_BY_ONE
private final SortFieldList	orderBy
private final GroupFieldList	partitionBy
private boolean	partitionByOne
private static final Set<SQLDialect>	REQUIRES_ORDER_BY_IN_LEAD_LAG
private static final Set<SQLDialect>	REQUIRES_ORDER_BY_IN_NTILE
private static final Set<SQLDialect>	REQUIRES_ORDER_BY_IN_PERCENT_RANK_CUME_DIST
private static final Set<SQLDialect>	REQUIRES_ORDER_BY_IN_RANK_DENSE_RANK
private final WindowDefinitionImpl	windowDefinition Deprecated as a consequence of `WindowDefinitionImpl` being deprecated.

Access	Constructor and Description
pack-priv	WindowSpecificationImpl()
pack-priv	WindowSpecificationImpl(WindowDefinitionImpl windowDefinition) Deprecated as a consequence of `WindowDefinitionImpl` being deprecated.

Method Summary

Modifier and Type	Method and Description
public final QOM.FrameExclude	$exclude() Implements org.jooq.WindowSpecification.$exclude. Experimental query object model accessor method, see also `QOM`.
public final Integer	$frameEnd() Implements org.jooq.WindowSpecification.$frameEnd. Experimental query object model accessor method, see also `QOM`.
public final Integer	$frameStart() Implements org.jooq.WindowSpecification.$frameStart. Experimental query object model accessor method, see also `QOM`.
public final QOM.FrameUnits	$frameUnits() Implements org.jooq.WindowSpecification.$frameUnits. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<? extends SortField<?>>	$orderBy() Implements org.jooq.WindowSpecification.$orderBy. Experimental query object model accessor method, see also `QOM`.
public final QOM.UnmodifiableList<? extends Field<?>>	$partitionBy() Implements org.jooq.WindowSpecification.$partitionBy. Experimental query object model accessor method, see also `QOM`.
public final WindowDefinitionImpl	$windowDefinition() Implements org.jooq.WindowSpecification.$windowDefinition. Deprecated as a consequence of `WindowDefinitionImpl` being deprecated. Experimental query object model accessor method, see also `QOM`.
public final void	accept(Context<?> ctx) Implements org.jooq.QueryPartInternal.accept. This `QueryPart` can `accept` a `Context` object in order to render a SQL string or to bind its variables.
public final WindowSpecificationExcludeStep	andCurrentRow() Implements org.jooq.WindowSpecificationRowsAndStep.andCurrentRow. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `… AND CURRENT ROW` frame clause to the window specification.
public final WindowSpecificationExcludeStep	andFollowing(int number) Implements org.jooq.WindowSpecificationRowsAndStep.andFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `… AND [number] FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	andPreceding(int number) Implements org.jooq.WindowSpecificationRowsAndStep.andPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `… AND [number] PRECEDING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	andUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsAndStep.andUnboundedFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `… AND UNBOUNDED FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	andUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsAndStep.andUnboundedPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `… AND UNBOUNDED PRECEDING` frame clause to the window specification.
pack-priv WindowSpecificationImpl	copy() Deprecated as a consequence of `WindowSpecificationImpl` being deprecated.
public final WindowSpecificationFinalStep	excludeCurrentRow() Implements org.jooq.WindowSpecificationExcludeStep.excludeCurrentRow. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. Add an `EXCLUDE CURRENT ROW` clause.
public final WindowSpecificationFinalStep	excludeGroup() Implements org.jooq.WindowSpecificationExcludeStep.excludeGroup. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. Add an `EXCLUDE GROUP` clause.
public final WindowSpecificationFinalStep	excludeNoOthers() Implements org.jooq.WindowSpecificationExcludeStep.excludeNoOthers. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. Add an `EXCLUDE NO OTHERS` clause.
public final WindowSpecificationFinalStep	excludeTies() Implements org.jooq.WindowSpecificationExcludeStep.excludeTies. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. Add an `EXCLUDE TIES` clause.
public final WindowSpecificationRowsAndStep	groupsBetweenCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenCurrentRow. Add a `GROUPS BETWEEN CURRENT ROW …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	groupsBetweenFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenFollowing. Add a `GROUPS BETWEEN [number] FOLLOWING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	groupsBetweenPreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenPreceding. Add a `GROUPS BETWEEN [number] PRECEDING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	groupsBetweenUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedFollowing. Add a `GROUPS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	groupsBetweenUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedPreceding. Add a `GROUPS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window specification.
public final WindowSpecificationExcludeStep	groupsCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.groupsCurrentRow. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `GROUPS CURRENT ROW` frame clause to the window specification.
public final WindowSpecificationExcludeStep	groupsFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `GROUPS [number] FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	groupsPreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `GROUPS [number] PRECEDING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	groupsUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.groupsUnboundedFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `GROUPS UNBOUNDED FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	groupsUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.groupsUnboundedPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `GROUPS UNBOUNDED PRECEDING` frame clause to the window specification.
public final WindowSpecificationOrderByStep	orderBy(OrderField<?>... fields) Implements org.jooq.WindowSpecificationOrderByStep.orderBy. Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. Add an `ORDER BY` clause to the window specification.
public final WindowSpecificationOrderByStep	orderBy(Collection<? extends OrderField<?>> fields) Implements org.jooq.WindowSpecificationOrderByStep.orderBy. Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. Add an `ORDER BY` clause to the window specification.
public final WindowSpecificationPartitionByStep	partitionBy(GroupField... fields) Implements org.jooq.WindowSpecificationPartitionByStep.partitionBy. Deprecated as a consequence of `WindowSpecificationPartitionByStep` being deprecated. Add a `PARTITION BY` clause to the window specification.
public final WindowSpecificationPartitionByStep	partitionBy(Collection<? extends GroupField> fields) Implements org.jooq.WindowSpecificationPartitionByStep.partitionBy. Deprecated as a consequence of `WindowSpecificationPartitionByStep` being deprecated. Add a `PARTITION BY` clause to the window specification.
public final WindowSpecificationOrderByStep	partitionByOne() Implements org.jooq.WindowSpecificationPartitionByStep.partitionByOne. Deprecated Add a `PARTITION BY 1` clause to the window specification, where such a clause is required by the syntax of an RDBMS.
public final WindowSpecificationRowsAndStep	rangeBetweenCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenCurrentRow. Add a `RANGE BETWEEN CURRENT ROW …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rangeBetweenFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenFollowing. Add a `RANGE BETWEEN [number] FOLLOWING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rangeBetweenPreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenPreceding. Add a `RANGE BETWEEN [number] PRECEDING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rangeBetweenUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenUnboundedFollowing. Add a `RANGE BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rangeBetweenUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenUnboundedPreceding. Add a `RANGE BETWEEN UNBOUNDED PRECEDING …` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rangeCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.rangeCurrentRow. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `RANGE CURRENT ROW` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rangeFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.rangeFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `RANGE [number] FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rangePreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.rangePreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `RANGE [number] PRECEDING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rangeUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.rangeUnboundedFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `RANGE UNBOUNDED FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rangeUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.rangeUnboundedPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `RANGE UNBOUNDED PRECEDING` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rowsBetweenCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenCurrentRow. Add a `ROWS BETWEEN CURRENT ROW …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rowsBetweenFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenFollowing. Add a `ROWS BETWEEN [number] FOLLOWING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rowsBetweenPreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenPreceding. Add a `ROWS BETWEEN [number] PRECEDING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rowsBetweenUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenUnboundedFollowing. Add a `ROWS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window specification.
public final WindowSpecificationRowsAndStep	rowsBetweenUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenUnboundedPreceding. Add a `ROWS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rowsCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.rowsCurrentRow. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `ROWS CURRENT ROW` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rowsFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.rowsFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `ROWS [number] FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rowsPreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.rowsPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `ROWS [number] PRECEDING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rowsUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.rowsUnboundedFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `ROWS UNBOUNDED FOLLOWING` frame clause to the window specification.
public final WindowSpecificationExcludeStep	rowsUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.rowsUnboundedPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. Add a `ROWS UNBOUNDED PRECEDING` frame clause to the window specification.
private final void	toSQLRows(Context<?> ctx, Integer rows)

Inherited from org.jooq.impl.AbstractQueryPart:: clauses configuration create create create declaresCTE declaresFields declaresTables declaresWindows equals generatesCast hashCode rendersContent toString translate

exclude	back to summary
private QOM.FrameExclude exclude

frameEnd	back to summary
private Integer frameEnd

frameStart	back to summary
private Integer frameStart

frameUnits	back to summary
private QOM.FrameUnits frameUnits

OMIT_PARTITION_BY_ONE	back to summary
private static final Set<SQLDialect> OMIT_PARTITION_BY_ONE

orderBy	back to summary
private final SortFieldList orderBy

partitionBy	back to summary
private final GroupFieldList partitionBy

partitionByOne	back to summary
private boolean partitionByOne

REQUIRES_ORDER_BY_IN_LEAD_LAG	back to summary
private static final Set<SQLDialect> REQUIRES_ORDER_BY_IN_LEAD_LAG

REQUIRES_ORDER_BY_IN_NTILE	back to summary
private static final Set<SQLDialect> REQUIRES_ORDER_BY_IN_NTILE

REQUIRES_ORDER_BY_IN_PERCENT_RANK_CUME_DIST	back to summary
private static final Set<SQLDialect> REQUIRES_ORDER_BY_IN_PERCENT_RANK_CUME_DIST

REQUIRES_ORDER_BY_IN_RANK_DENSE_RANK	back to summary
private static final Set<SQLDialect> REQUIRES_ORDER_BY_IN_RANK_DENSE_RANK

windowDefinition	back to summary
private final WindowDefinitionImpl windowDefinition Deprecated as a consequence of `WindowDefinitionImpl` being deprecated. See corresponding docs for further information.

WindowSpecificationImpl	back to summary
pack-priv WindowSpecificationImpl()

WindowSpecificationImpl	back to summary
pack-priv WindowSpecificationImpl(WindowDefinitionImpl windowDefinition) Deprecated as a consequence of `WindowDefinitionImpl` being deprecated. See corresponding docs for further information.

Method Detail

$exclude back to summary

$exclude	back to summary
public final QOM.FrameExclude $exclude() Implements org.jooq.WindowSpecification.$exclude. Doc from org.jooq.WindowSpecification.$exclude. Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Override

public final QOM.FrameExclude $exclude()

Implements org.jooq.WindowSpecification.$exclude.

Doc from org.jooq.WindowSpecification.$exclude.

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

Annotations

@Override

$frameEnd back to summary

$frameEnd	back to summary
public final Integer $frameEnd() Implements org.jooq.WindowSpecification.$frameEnd. Doc from org.jooq.WindowSpecification.$frameEnd. Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Override

public final Integer $frameEnd()

Implements org.jooq.WindowSpecification.$frameEnd.

Doc from org.jooq.WindowSpecification.$frameEnd.

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

Annotations

@Override

$frameStart back to summary

$frameStart	back to summary
public final Integer $frameStart() Implements org.jooq.WindowSpecification.$frameStart. Doc from org.jooq.WindowSpecification.$frameStart. Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Override

public final Integer $frameStart()

Implements org.jooq.WindowSpecification.$frameStart.

Doc from org.jooq.WindowSpecification.$frameStart.

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

Annotations

@Override

$frameUnits back to summary

$frameUnits	back to summary
public final QOM.FrameUnits $frameUnits() Implements org.jooq.WindowSpecification.$frameUnits. Doc from org.jooq.WindowSpecification.$frameUnits. Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Override

public final QOM.FrameUnits $frameUnits()

Implements org.jooq.WindowSpecification.$frameUnits.

Doc from org.jooq.WindowSpecification.$frameUnits.

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

Annotations

@Override

$orderBy back to summary

$orderBy	back to summary
public final QOM.UnmodifiableList<? extends SortField<?>> $orderBy() Implements org.jooq.WindowSpecification.$orderBy. Doc from org.jooq.WindowSpecification.$orderBy. Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Override

public final QOM.UnmodifiableList<? extends SortField<?>> $orderBy()

Implements org.jooq.WindowSpecification.$orderBy.

Doc from org.jooq.WindowSpecification.$orderBy.

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

Annotations

@Override

$partitionBy back to summary

$partitionBy	back to summary
public final QOM.UnmodifiableList<? extends Field<?>> $partitionBy() Implements org.jooq.WindowSpecification.$partitionBy. Doc from org.jooq.WindowSpecification.$partitionBy. Experimental query object model accessor method, see also `QOM`. Subject to change in future jOOQ versions, use at your own risk. Annotations @Override

public final QOM.UnmodifiableList<? extends Field<?>> $partitionBy()

Implements org.jooq.WindowSpecification.$partitionBy.

Doc from org.jooq.WindowSpecification.$partitionBy.

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

Annotations

@Override

$windowDefinition back to summary

$windowDefinition	back to summary
public final WindowDefinitionImpl $windowDefinition() Implements org.jooq.WindowSpecification.$windowDefinition. Doc from org.jooq.WindowSpecification.$windowDefinition. Deprecated as a consequence of `WindowDefinitionImpl` 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 @Override

public final WindowDefinitionImpl $windowDefinition()

Implements org.jooq.WindowSpecification.$windowDefinition.

Doc from org.jooq.WindowSpecification.$windowDefinition.

Deprecated

as a consequence of WindowDefinitionImpl 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

@Override

accept back to summary

accept	back to summary
public final void accept(Context<?> ctx) Implements org.jooq.QueryPartInternal.accept. Doc from org.jooq.QueryPartInternal.accept. This `QueryPart` can `accept` a `Context` object in order to render a SQL string or to bind its variables. Annotations @Override

public final void accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations

@Override

andCurrentRow back to summary

andCurrentRow	back to summary
public final WindowSpecificationExcludeStep andCurrentRow() Implements org.jooq.WindowSpecificationRowsAndStep.andCurrentRow. Doc from org.jooq.WindowSpecificationRowsAndStep.andCurrentRow. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `… AND CURRENT ROW` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep andCurrentRow()

Implements org.jooq.WindowSpecificationRowsAndStep.andCurrentRow.

Doc from org.jooq.WindowSpecificationRowsAndStep.andCurrentRow.

Deprecated

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

Add a … AND CURRENT ROW frame clause to the window specification.

Annotations

@Override

andFollowing back to summary

andFollowing	back to summary
public final WindowSpecificationExcludeStep andFollowing(int number) Implements org.jooq.WindowSpecificationRowsAndStep.andFollowing. Doc from org.jooq.WindowSpecificationRowsAndStep.andFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `… AND [number] FOLLOWING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep andFollowing(int number)

Implements org.jooq.WindowSpecificationRowsAndStep.andFollowing.

Doc from org.jooq.WindowSpecificationRowsAndStep.andFollowing.

Deprecated

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

Add a … AND [number] FOLLOWING frame clause to the window specification.

Annotations

@Override

andPreceding back to summary

andPreceding	back to summary
public final WindowSpecificationExcludeStep andPreceding(int number) Implements org.jooq.WindowSpecificationRowsAndStep.andPreceding. Doc from org.jooq.WindowSpecificationRowsAndStep.andPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `… AND [number] PRECEDING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep andPreceding(int number)

Implements org.jooq.WindowSpecificationRowsAndStep.andPreceding.

Doc from org.jooq.WindowSpecificationRowsAndStep.andPreceding.

Deprecated

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

Add a … AND [number] PRECEDING frame clause to the window specification.

Annotations

@Override

andUnboundedFollowing back to summary

andUnboundedFollowing	back to summary
public final WindowSpecificationExcludeStep andUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsAndStep.andUnboundedFollowing. Doc from org.jooq.WindowSpecificationRowsAndStep.andUnboundedFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `… AND UNBOUNDED FOLLOWING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep andUnboundedFollowing()

Implements org.jooq.WindowSpecificationRowsAndStep.andUnboundedFollowing.

Doc from org.jooq.WindowSpecificationRowsAndStep.andUnboundedFollowing.

Deprecated

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

Add a … AND UNBOUNDED FOLLOWING frame clause to the window specification.

Annotations

@Override

andUnboundedPreceding back to summary

andUnboundedPreceding	back to summary
public final WindowSpecificationExcludeStep andUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsAndStep.andUnboundedPreceding. Doc from org.jooq.WindowSpecificationRowsAndStep.andUnboundedPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `… AND UNBOUNDED PRECEDING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep andUnboundedPreceding()

Implements org.jooq.WindowSpecificationRowsAndStep.andUnboundedPreceding.

Doc from org.jooq.WindowSpecificationRowsAndStep.andUnboundedPreceding.

Deprecated

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

Add a … AND UNBOUNDED PRECEDING frame clause to the window specification.

Annotations

@Override

copy	back to summary
pack-priv WindowSpecificationImpl copy() Deprecated as a consequence of `WindowSpecificationImpl` being deprecated. See corresponding docs for further information.

excludeCurrentRow back to summary

excludeCurrentRow	back to summary
public final WindowSpecificationFinalStep excludeCurrentRow() Implements org.jooq.WindowSpecificationExcludeStep.excludeCurrentRow. Doc from org.jooq.WindowSpecificationExcludeStep.excludeCurrentRow. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. See corresponding docs for further information. Add an `EXCLUDE CURRENT ROW` clause. Annotations @Override

public final WindowSpecificationFinalStep excludeCurrentRow()

Implements org.jooq.WindowSpecificationExcludeStep.excludeCurrentRow.

Doc from org.jooq.WindowSpecificationExcludeStep.excludeCurrentRow.

Deprecated

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

Add an EXCLUDE CURRENT ROW clause.

Annotations

@Override

excludeGroup back to summary

excludeGroup	back to summary
public final WindowSpecificationFinalStep excludeGroup() Implements org.jooq.WindowSpecificationExcludeStep.excludeGroup. Doc from org.jooq.WindowSpecificationExcludeStep.excludeGroup. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. See corresponding docs for further information. Add an `EXCLUDE GROUP` clause. Annotations @Override

public final WindowSpecificationFinalStep excludeGroup()

Implements org.jooq.WindowSpecificationExcludeStep.excludeGroup.

Doc from org.jooq.WindowSpecificationExcludeStep.excludeGroup.

Deprecated

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

Add an EXCLUDE GROUP clause.

Annotations

@Override

excludeNoOthers back to summary

excludeNoOthers	back to summary
public final WindowSpecificationFinalStep excludeNoOthers() Implements org.jooq.WindowSpecificationExcludeStep.excludeNoOthers. Doc from org.jooq.WindowSpecificationExcludeStep.excludeNoOthers. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. See corresponding docs for further information. Add an `EXCLUDE NO OTHERS` clause. Annotations @Override

public final WindowSpecificationFinalStep excludeNoOthers()

Implements org.jooq.WindowSpecificationExcludeStep.excludeNoOthers.

Doc from org.jooq.WindowSpecificationExcludeStep.excludeNoOthers.

Deprecated

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

Add an EXCLUDE NO OTHERS clause.

Annotations

@Override

excludeTies back to summary

excludeTies	back to summary
public final WindowSpecificationFinalStep excludeTies() Implements org.jooq.WindowSpecificationExcludeStep.excludeTies. Doc from org.jooq.WindowSpecificationExcludeStep.excludeTies. Deprecated as a consequence of `WindowSpecificationFinalStep` being deprecated. See corresponding docs for further information. Add an `EXCLUDE TIES` clause. Annotations @Override

public final WindowSpecificationFinalStep excludeTies()

Implements org.jooq.WindowSpecificationExcludeStep.excludeTies.

Doc from org.jooq.WindowSpecificationExcludeStep.excludeTies.

Deprecated

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

Add an EXCLUDE TIES clause.

Annotations

@Override

groupsBetweenCurrentRow back to summary

groupsBetweenCurrentRow	back to summary
public final WindowSpecificationRowsAndStep groupsBetweenCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenCurrentRow. Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenCurrentRow. Add a `GROUPS BETWEEN CURRENT ROW …` frame clause to the window specification. Annotations @Override

public final WindowSpecificationRowsAndStep groupsBetweenCurrentRow()

Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenCurrentRow.

Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenCurrentRow.

Add a GROUPS BETWEEN CURRENT ROW … frame clause to the window specification.

Annotations

@Override

groupsBetweenFollowing back to summary

groupsBetweenFollowing	back to summary
public final WindowSpecificationRowsAndStep groupsBetweenFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenFollowing. Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenFollowing. Add a `GROUPS BETWEEN [number] FOLLOWING …` frame clause to the window specification. Annotations @Override

public final WindowSpecificationRowsAndStep groupsBetweenFollowing(int number)

Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenFollowing.

Add a GROUPS BETWEEN [number] FOLLOWING … frame clause to the window specification.

Annotations

@Override

groupsBetweenPreceding back to summary

groupsBetweenPreceding	back to summary
public final WindowSpecificationRowsAndStep groupsBetweenPreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenPreceding. Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenPreceding. Add a `GROUPS BETWEEN [number] PRECEDING …` frame clause to the window specification. Annotations @Override

public final WindowSpecificationRowsAndStep groupsBetweenPreceding(int number)

Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenPreceding.

Add a GROUPS BETWEEN [number] PRECEDING … frame clause to the window specification.

Annotations

@Override

groupsBetweenUnboundedFollowing back to summary

groupsBetweenUnboundedFollowing	back to summary
public final WindowSpecificationRowsAndStep groupsBetweenUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedFollowing. Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedFollowing. Add a `GROUPS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window specification. Annotations @Override

public final WindowSpecificationRowsAndStep groupsBetweenUnboundedFollowing()

Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedFollowing.

Add a GROUPS BETWEEN UNBOUNDED FOLLOWING … frame clause to the window specification.

Annotations

@Override

groupsBetweenUnboundedPreceding back to summary

groupsBetweenUnboundedPreceding	back to summary
public final WindowSpecificationRowsAndStep groupsBetweenUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedPreceding. Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedPreceding. Add a `GROUPS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window specification. Annotations @Override

public final WindowSpecificationRowsAndStep groupsBetweenUnboundedPreceding()

Implements org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.groupsBetweenUnboundedPreceding.

Add a GROUPS BETWEEN UNBOUNDED PRECEDING … frame clause to the window specification.

Annotations

@Override

groupsCurrentRow back to summary

groupsCurrentRow	back to summary
public final WindowSpecificationExcludeStep groupsCurrentRow() Implements org.jooq.WindowSpecificationRowsStep.groupsCurrentRow. Doc from org.jooq.WindowSpecificationRowsStep.groupsCurrentRow. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS CURRENT ROW` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep groupsCurrentRow()

Implements org.jooq.WindowSpecificationRowsStep.groupsCurrentRow.

Doc from org.jooq.WindowSpecificationRowsStep.groupsCurrentRow.

Deprecated

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

Add a GROUPS CURRENT ROW frame clause to the window specification.

Annotations

@Override

groupsFollowing back to summary

groupsFollowing	back to summary
public final WindowSpecificationExcludeStep groupsFollowing(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsFollowing. Doc from org.jooq.WindowSpecificationRowsStep.groupsFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS [number] FOLLOWING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep groupsFollowing(int number)

Implements org.jooq.WindowSpecificationRowsStep.groupsFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.groupsFollowing.

Deprecated

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

Add a GROUPS [number] FOLLOWING frame clause to the window specification.

Annotations

@Override

groupsPreceding back to summary

groupsPreceding	back to summary
public final WindowSpecificationExcludeStep groupsPreceding(int number) Implements org.jooq.WindowSpecificationRowsStep.groupsPreceding. Doc from org.jooq.WindowSpecificationRowsStep.groupsPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS [number] PRECEDING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep groupsPreceding(int number)

Implements org.jooq.WindowSpecificationRowsStep.groupsPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.groupsPreceding.

Deprecated

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

Add a GROUPS [number] PRECEDING frame clause to the window specification.

Annotations

@Override

groupsUnboundedFollowing back to summary

groupsUnboundedFollowing	back to summary
public final WindowSpecificationExcludeStep groupsUnboundedFollowing() Implements org.jooq.WindowSpecificationRowsStep.groupsUnboundedFollowing. Doc from org.jooq.WindowSpecificationRowsStep.groupsUnboundedFollowing. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS UNBOUNDED FOLLOWING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep groupsUnboundedFollowing()

Implements org.jooq.WindowSpecificationRowsStep.groupsUnboundedFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.groupsUnboundedFollowing.

Deprecated

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

Add a GROUPS UNBOUNDED FOLLOWING frame clause to the window specification.

Annotations

@Override

groupsUnboundedPreceding back to summary

groupsUnboundedPreceding	back to summary
public final WindowSpecificationExcludeStep groupsUnboundedPreceding() Implements org.jooq.WindowSpecificationRowsStep.groupsUnboundedPreceding. Doc from org.jooq.WindowSpecificationRowsStep.groupsUnboundedPreceding. Deprecated as a consequence of `WindowSpecificationExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS UNBOUNDED PRECEDING` frame clause to the window specification. Annotations @Override

public final WindowSpecificationExcludeStep groupsUnboundedPreceding()

Implements org.jooq.WindowSpecificationRowsStep.groupsUnboundedPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.groupsUnboundedPreceding.

Deprecated

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

Add a GROUPS UNBOUNDED PRECEDING frame clause to the window specification.

Annotations

@Override

orderBy back to summary

orderBy	back to summary
public final WindowSpecificationOrderByStep orderBy(OrderField<?>... fields) Implements org.jooq.WindowSpecificationOrderByStep.orderBy. Doc from org.jooq.WindowSpecificationOrderByStep.orderBy. Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. See corresponding docs for further information. Add an `ORDER BY` clause to the window specification. Annotations @Override

public final WindowSpecificationOrderByStep orderBy(OrderField<?>... fields)

Implements org.jooq.WindowSpecificationOrderByStep.orderBy.

Doc from org.jooq.WindowSpecificationOrderByStep.orderBy.

Deprecated

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

Add an ORDER BY clause to the window specification.

Annotations

@Override

orderBy back to summary

orderBy	back to summary
public final WindowSpecificationOrderByStep orderBy(Collection<? extends OrderField<?>> fields) Implements org.jooq.WindowSpecificationOrderByStep.orderBy. Doc from org.jooq.WindowSpecificationOrderByStep.orderBy. Deprecated as a consequence of `WindowSpecificationOrderByStep` being deprecated. See corresponding docs for further information. Add an `ORDER BY` clause to the window specification. Annotations @Override

public final WindowSpecificationOrderByStep orderBy(Collection<? extends OrderField<?>> fields)

Implements org.jooq.WindowSpecificationOrderByStep.orderBy.

Doc from org.jooq.WindowSpecificationOrderByStep.orderBy.

Deprecated

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

Add an ORDER BY clause to the window specification.

Annotations

@Override

partitionBy back to summary

partitionBy	back to summary
public final WindowSpecificationPartitionByStep partitionBy(GroupField... fields) Implements org.jooq.WindowSpecificationPartitionByStep.partitionBy. Doc from org.jooq.WindowSpecificationPartitionByStep.partitionBy. Deprecated as a consequence of `WindowSpecificationPartitionByStep` being deprecated. See corresponding docs for further information. Add a `PARTITION BY` clause to the window specification. Annotations @Override

public final WindowSpecificationPartitionByStep partitionBy(GroupField... fields)

Implements org.jooq.WindowSpecificationPartitionByStep.partitionBy.

Doc from org.jooq.WindowSpecificationPartitionByStep.partitionBy.

Deprecated

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

Add a PARTITION BY clause to the window specification.

Annotations

@Override

partitionBy back to summary

partitionBy	back to summary
public final WindowSpecificationPartitionByStep partitionBy(Collection<? extends GroupField> fields) Implements org.jooq.WindowSpecificationPartitionByStep.partitionBy. Doc from org.jooq.WindowSpecificationPartitionByStep.partitionBy. Deprecated as a consequence of `WindowSpecificationPartitionByStep` being deprecated. See corresponding docs for further information. Add a `PARTITION BY` clause to the window specification. Annotations @Override

public final WindowSpecificationPartitionByStep partitionBy(Collection<? extends GroupField> fields)

Implements org.jooq.WindowSpecificationPartitionByStep.partitionBy.

Doc from org.jooq.WindowSpecificationPartitionByStep.partitionBy.

Deprecated

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

Add a PARTITION BY clause to the window specification.

Annotations

@Override

partitionByOne back to summary

public final WindowSpecificationOrderByStep partitionByOne()

Implements org.jooq.WindowSpecificationPartitionByStep.partitionByOne.

Doc from org.jooq.WindowSpecificationPartitionByStep.partitionByOne.

Deprecated

Add a PARTITION BY 1 clause to the window specification, where such a clause is required by the syntax of an RDBMS.

Annotations

@Override
@Deprecated

rangeBetweenCurrentRow back to summary

public final WindowSpecificationRowsAndStep rangeBetweenCurrentRow()

Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenCurrentRow.

Doc from org.jooq.WindowSpecificationRowsStep.rangeBetweenCurrentRow.

Add a RANGE BETWEEN CURRENT ROW … frame clause to the window specification.

Annotations

@Override

rangeBetweenFollowing back to summary

public final WindowSpecificationRowsAndStep rangeBetweenFollowing(int number)

Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rangeBetweenFollowing.

Add a RANGE BETWEEN [number] FOLLOWING … frame clause to the window specification.

Annotations

@Override

rangeBetweenPreceding back to summary

public final WindowSpecificationRowsAndStep rangeBetweenPreceding(int number)

Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rangeBetweenPreceding.

Add a RANGE BETWEEN [number] PRECEDING … frame clause to the window specification.

Annotations

@Override

rangeBetweenUnboundedFollowing back to summary

public final WindowSpecificationRowsAndStep rangeBetweenUnboundedFollowing()

Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenUnboundedFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rangeBetweenUnboundedFollowing.

Add a RANGE BETWEEN UNBOUNDED FOLLOWING … frame clause to the window specification.

Annotations

@Override

rangeBetweenUnboundedPreceding back to summary

public final WindowSpecificationRowsAndStep rangeBetweenUnboundedPreceding()

Implements org.jooq.WindowSpecificationRowsStep.rangeBetweenUnboundedPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rangeBetweenUnboundedPreceding.

Add a RANGE BETWEEN UNBOUNDED PRECEDING … frame clause to the window specification.

Annotations

@Override

rangeCurrentRow back to summary

public final WindowSpecificationExcludeStep rangeCurrentRow()

Implements org.jooq.WindowSpecificationRowsStep.rangeCurrentRow.

Doc from org.jooq.WindowSpecificationRowsStep.rangeCurrentRow.

Deprecated

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

Add a RANGE CURRENT ROW frame clause to the window specification.

Annotations

@Override

rangeFollowing back to summary

public final WindowSpecificationExcludeStep rangeFollowing(int number)

Implements org.jooq.WindowSpecificationRowsStep.rangeFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rangeFollowing.

Deprecated

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

Add a RANGE [number] FOLLOWING frame clause to the window specification.

Annotations

@Override

rangePreceding back to summary

public final WindowSpecificationExcludeStep rangePreceding(int number)

Implements org.jooq.WindowSpecificationRowsStep.rangePreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rangePreceding.

Deprecated

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

Add a RANGE [number] PRECEDING frame clause to the window specification.

Annotations

@Override

rangeUnboundedFollowing back to summary

public final WindowSpecificationExcludeStep rangeUnboundedFollowing()

Implements org.jooq.WindowSpecificationRowsStep.rangeUnboundedFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rangeUnboundedFollowing.

Deprecated

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

Add a RANGE UNBOUNDED FOLLOWING frame clause to the window specification.

Annotations

@Override

rangeUnboundedPreceding back to summary

public final WindowSpecificationExcludeStep rangeUnboundedPreceding()

Implements org.jooq.WindowSpecificationRowsStep.rangeUnboundedPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rangeUnboundedPreceding.

Deprecated

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

Add a RANGE UNBOUNDED PRECEDING frame clause to the window specification.

Annotations

@Override

rowsBetweenCurrentRow back to summary

public final WindowSpecificationRowsAndStep rowsBetweenCurrentRow()

Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenCurrentRow.

Doc from org.jooq.WindowSpecificationRowsStep.rowsBetweenCurrentRow.

Add a ROWS BETWEEN CURRENT ROW … frame clause to the window specification.

Annotations

@Override

rowsBetweenFollowing back to summary

public final WindowSpecificationRowsAndStep rowsBetweenFollowing(int number)

Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rowsBetweenFollowing.

Add a ROWS BETWEEN [number] FOLLOWING … frame clause to the window specification.

Annotations

@Override

rowsBetweenPreceding back to summary

public final WindowSpecificationRowsAndStep rowsBetweenPreceding(int number)

Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rowsBetweenPreceding.

Add a ROWS BETWEEN [number] PRECEDING … frame clause to the window specification.

Annotations

@Override

rowsBetweenUnboundedFollowing back to summary

public final WindowSpecificationRowsAndStep rowsBetweenUnboundedFollowing()

Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenUnboundedFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rowsBetweenUnboundedFollowing.

Add a ROWS BETWEEN UNBOUNDED FOLLOWING … frame clause to the window specification.

Annotations

@Override

rowsBetweenUnboundedPreceding back to summary

public final WindowSpecificationRowsAndStep rowsBetweenUnboundedPreceding()

Implements org.jooq.WindowSpecificationRowsStep.rowsBetweenUnboundedPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rowsBetweenUnboundedPreceding.

Add a ROWS BETWEEN UNBOUNDED PRECEDING … frame clause to the window specification.

Annotations

@Override

rowsCurrentRow back to summary

public final WindowSpecificationExcludeStep rowsCurrentRow()

Implements org.jooq.WindowSpecificationRowsStep.rowsCurrentRow.

Doc from org.jooq.WindowSpecificationRowsStep.rowsCurrentRow.

Deprecated

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

Add a ROWS CURRENT ROW frame clause to the window specification.

Annotations

@Override

rowsFollowing back to summary

public final WindowSpecificationExcludeStep rowsFollowing(int number)

Implements org.jooq.WindowSpecificationRowsStep.rowsFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rowsFollowing.

Deprecated

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

Add a ROWS [number] FOLLOWING frame clause to the window specification.

Annotations

@Override

rowsPreceding back to summary

public final WindowSpecificationExcludeStep rowsPreceding(int number)

Implements org.jooq.WindowSpecificationRowsStep.rowsPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rowsPreceding.

Deprecated

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

Add a ROWS [number] PRECEDING frame clause to the window specification.

Annotations

@Override

rowsUnboundedFollowing back to summary

public final WindowSpecificationExcludeStep rowsUnboundedFollowing()

Implements org.jooq.WindowSpecificationRowsStep.rowsUnboundedFollowing.

Doc from org.jooq.WindowSpecificationRowsStep.rowsUnboundedFollowing.

Deprecated

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

Add a ROWS UNBOUNDED FOLLOWING frame clause to the window specification.

Annotations

@Override

rowsUnboundedPreceding back to summary

public final WindowSpecificationExcludeStep rowsUnboundedPreceding()

Implements org.jooq.WindowSpecificationRowsStep.rowsUnboundedPreceding.

Doc from org.jooq.WindowSpecificationRowsStep.rowsUnboundedPreceding.

Deprecated

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

Add a ROWS UNBOUNDED PRECEDING frame clause to the window specification.

Annotations

@Override

toSQLRows	back to summary
private final void toSQLRows(Context<?> ctx, Integer rows)

pack-priv final Class WindowSpecificationImpl

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail