jOOQ 3.18.7 · org.jooq.impl.AbstractWindowFunction

Modifier and Type	Field and Description
pack-priv QOM.FromFirstOrLast	fromFirstOrLast
pack-priv QOM.NullTreatment	nullTreatment
private static final Set<SQLDialect>	SUPPORT_NO_PARENS_WINDOW_REFERENCE
pack-priv WindowDefinitionImpl	windowDefinition Deprecated as a consequence of `WindowDefinitionImpl` being deprecated.
pack-priv Name	windowName
pack-priv WindowSpecificationImpl	windowSpecification Deprecated as a consequence of `WindowSpecificationImpl` being deprecated.

Access	Constructor and Description
pack-priv	AbstractWindowFunction(Name name, DataType<T> type)

Method Summary

Modifier and Type	Method and Description
public final QOM.FromFirstOrLast	$fromFirstOrLast()
pack-priv final AbstractWindowFunction<T>	$fromFirstOrLast(QOM.FromFirstOrLast f) Deprecated as a consequence of `AbstractWindowFunction` being deprecated.
public final QOM.NullTreatment	$nullTreatment()
pack-priv final AbstractWindowFunction<T>	$nullTreatment(QOM.NullTreatment n) Deprecated as a consequence of `AbstractWindowFunction` being deprecated.
public final WindowDefinition	$windowDefinition() Implements org.jooq.impl.QOM.WindowFunction.$windowDefinition. Deprecated as a consequence of `WindowDefinition` being deprecated.
pack-priv final AbstractWindowFunction<T>	$windowDefinition(WindowDefinition d) Deprecated as a consequence of `WindowDefinition` and `AbstractWindowFunction` being deprecated.
public final WindowSpecification	$windowSpecification() Implements org.jooq.impl.QOM.WindowFunction.$windowSpecification.
pack-priv final AbstractWindowFunction<T>	$windowSpecification(WindowSpecification s) Deprecated as a consequence of `AbstractWindowFunction` being deprecated.
pack-priv final void	acceptFromFirstOrLast(Context<?> ctx)
pack-priv final void	acceptNullTreatment(Context<?> ctx)
pack-priv final void	acceptNullTreatmentStandard(Context<?> ctx)
pack-priv final void	acceptOverClause(Context<?> ctx)
public final WindowExcludeStep<T>	andCurrentRow() Implements org.jooq.WindowRowsAndStep.andCurrentRow. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `… AND CURRENT ROW` frame clause to the window function.
public final WindowExcludeStep<T>	andFollowing(int number) Implements org.jooq.WindowRowsAndStep.andFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `… AND [number] FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	andPreceding(int number) Implements org.jooq.WindowRowsAndStep.andPreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `… AND [number] PRECEDING` frame clause to the window function.
public final WindowExcludeStep<T>	andUnboundedFollowing() Implements org.jooq.WindowRowsAndStep.andUnboundedFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `… AND UNBOUNDED FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	andUnboundedPreceding() Implements org.jooq.WindowRowsAndStep.andUnboundedPreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `… AND UNBOUNDED PRECEDING` frame clause to the window function.
public final WindowFinalStep<T>	excludeCurrentRow() Implements org.jooq.WindowExcludeStep.excludeCurrentRow. Deprecated as a consequence of `WindowFinalStep` being deprecated. Add an `EXCLUDE CURRENT ROW` clause.
public final WindowFinalStep<T>	excludeGroup() Implements org.jooq.WindowExcludeStep.excludeGroup. Deprecated as a consequence of `WindowFinalStep` being deprecated. Add an `EXCLUDE GROUP` clause.
public final WindowFinalStep<T>	excludeNoOthers() Implements org.jooq.WindowExcludeStep.excludeNoOthers. Deprecated as a consequence of `WindowFinalStep` being deprecated. Add an `EXCLUDE NO OTHERS` clause.
public final WindowFinalStep<T>	excludeTies() Implements org.jooq.WindowExcludeStep.excludeTies. Deprecated as a consequence of `WindowFinalStep` being deprecated. Add an `EXCLUDE TIES` clause.
public final WindowIgnoreNullsStep<T>	fromFirst() Implements org.jooq.WindowFromFirstLastStep.fromFirst. Add an `FROM FIRST` clause to the window function.
public final WindowIgnoreNullsStep<T>	fromLast() Implements org.jooq.WindowFromFirstLastStep.fromLast. Add a `FROM LAST` clause to the window function.
public final WindowRowsAndStep<T>	groupsBetweenCurrentRow() Implements org.jooq.WindowRowsStep.groupsBetweenCurrentRow. Add a `GROUPS BETWEEN CURRENT ROW …` frame clause to the window function.
public final WindowRowsAndStep<T>	groupsBetweenFollowing(int number) Implements org.jooq.WindowRowsStep.groupsBetweenFollowing. Add a `GROUPS BETWEEN [number] FOLLOWING …` frame clause to the window function.
public final WindowRowsAndStep<T>	groupsBetweenPreceding(int number) Implements org.jooq.WindowRowsStep.groupsBetweenPreceding. Add a `GROUPS BETWEEN [number] PRECEDING …` frame clause to the window function.
public final WindowRowsAndStep<T>	groupsBetweenUnboundedFollowing() Implements org.jooq.WindowRowsStep.groupsBetweenUnboundedFollowing. Add a `GROUPS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function.
public final WindowRowsAndStep<T>	groupsBetweenUnboundedPreceding() Implements org.jooq.WindowRowsStep.groupsBetweenUnboundedPreceding. Add a `GROUPS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function.
public final WindowExcludeStep<T>	groupsCurrentRow() Implements org.jooq.WindowRowsStep.groupsCurrentRow. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS CURRENT ROW` frame clause to the window function.
public final WindowExcludeStep<T>	groupsFollowing(int number) Implements org.jooq.WindowRowsStep.groupsFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS [number] FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	groupsPreceding(int number) Implements org.jooq.WindowRowsStep.groupsPreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS [number] PRECEDING` frame clause to the window function.
public final WindowExcludeStep<T>	groupsUnboundedFollowing() Implements org.jooq.WindowRowsStep.groupsUnboundedFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS UNBOUNDED FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	groupsUnboundedPreceding() Implements org.jooq.WindowRowsStep.groupsUnboundedPreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS UNBOUNDED PRECEDING` frame clause to the window function.
public final WindowOverStep<T>	ignoreNulls() Implements org.jooq.WindowIgnoreNullsStep.ignoreNulls. Add an `IGNORE NULLS` clause to the window function.
pack-priv final boolean	isWindow()
public AbstractWindowFunction<T>	orderBy(OrderField<?>... fields) Implements org.jooq.WindowOrderByStep.orderBy. Deprecated as a consequence of `AbstractWindowFunction` being deprecated. Add an `ORDER BY` clause to the window function.
public AbstractWindowFunction<T>	orderBy(Collection<? extends OrderField<?>> fields) Implements org.jooq.WindowOrderByStep.orderBy. Deprecated as a consequence of `AbstractWindowFunction` being deprecated. Add an `ORDER BY` clause to the window function.
public final WindowPartitionByStep<T>	over() Implements org.jooq.WindowOverStep.over. Deprecated as a consequence of `WindowPartitionByStep` being deprecated. Turn this aggregate function into a window function.
public final WindowFinalStep<T>	over(WindowSpecification specification) Implements org.jooq.WindowOverStep.over. Deprecated as a consequence of `WindowFinalStep` being deprecated. Turn this aggregate function into a window function.
public final WindowFinalStep<T>	over(WindowDefinition definition) Implements org.jooq.WindowOverStep.over. Deprecated as a consequence of `WindowDefinition` and `WindowFinalStep` being deprecated. Turn this aggregate function into a window function referencing a window definition.
public final WindowFinalStep<T>	over(String n) Implements org.jooq.WindowOverStep.over. Deprecated as a consequence of `WindowFinalStep` being deprecated. Turn this aggregate function into a window function referencing a window name.
public final WindowFinalStep<T>	over(Name n) Implements org.jooq.WindowOverStep.over. Deprecated as a consequence of `WindowFinalStep` being deprecated. Turn this aggregate function into a window function referencing a window name.
public final WindowOrderByStep<T>	partitionBy(GroupField... fields) Implements org.jooq.WindowPartitionByStep.partitionBy. Deprecated as a consequence of `WindowOrderByStep` being deprecated. Add a `PARTITION BY` clause to the window functions.
public final WindowOrderByStep<T>	partitionBy(Collection<? extends GroupField> fields) Implements org.jooq.WindowPartitionByStep.partitionBy. Deprecated as a consequence of `WindowOrderByStep` being deprecated. Add a `PARTITION BY` clause to the window functions.
public final WindowOrderByStep<T>	partitionByOne() Implements org.jooq.WindowPartitionByStep.partitionByOne. Deprecated Add a `PARTITION BY 1` clause to the window functions, where such a clause is required by the syntax of an RDBMS.
public final WindowRowsAndStep<T>	rangeBetweenCurrentRow() Implements org.jooq.WindowRowsStep.rangeBetweenCurrentRow. Add a `RANGE BETWEEN CURRENT ROW …` frame clause to the window function.
public final WindowRowsAndStep<T>	rangeBetweenFollowing(int number) Implements org.jooq.WindowRowsStep.rangeBetweenFollowing. Add a `RANGE BETWEEN [number] FOLLOWING …` frame clause to the window function.
public final WindowRowsAndStep<T>	rangeBetweenPreceding(int number) Implements org.jooq.WindowRowsStep.rangeBetweenPreceding. Add a `RANGE BETWEEN [number] PRECEDING …` frame clause to the window function.
public final WindowRowsAndStep<T>	rangeBetweenUnboundedFollowing() Implements org.jooq.WindowRowsStep.rangeBetweenUnboundedFollowing. Add a `RANGE BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function.
public final WindowRowsAndStep<T>	rangeBetweenUnboundedPreceding() Implements org.jooq.WindowRowsStep.rangeBetweenUnboundedPreceding. Add a `RANGE BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function.
public final WindowExcludeStep<T>	rangeCurrentRow() Implements org.jooq.WindowRowsStep.rangeCurrentRow. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE CURRENT ROW` frame clause to the window function.
public final WindowExcludeStep<T>	rangeFollowing(int number) Implements org.jooq.WindowRowsStep.rangeFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE [number] FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	rangePreceding(int number) Implements org.jooq.WindowRowsStep.rangePreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE [number] PRECEDING` frame clause to the window function.
public final WindowExcludeStep<T>	rangeUnboundedFollowing() Implements org.jooq.WindowRowsStep.rangeUnboundedFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE UNBOUNDED FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	rangeUnboundedPreceding() Implements org.jooq.WindowRowsStep.rangeUnboundedPreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE UNBOUNDED PRECEDING` frame clause to the window function.
public final WindowOverStep<T>	respectNulls() Implements org.jooq.WindowIgnoreNullsStep.respectNulls. Add a `RESPECT NULLS` clause to the window function.
public final WindowRowsAndStep<T>	rowsBetweenCurrentRow() Implements org.jooq.WindowRowsStep.rowsBetweenCurrentRow. Add a `ROWS BETWEEN CURRENT ROW …` frame clause to the window function.
public final WindowRowsAndStep<T>	rowsBetweenFollowing(int number) Implements org.jooq.WindowRowsStep.rowsBetweenFollowing. Add a `ROWS BETWEEN [number] FOLLOWING …` frame clause to the window function.
public final WindowRowsAndStep<T>	rowsBetweenPreceding(int number) Implements org.jooq.WindowRowsStep.rowsBetweenPreceding. Add a `ROWS BETWEEN [number] PRECEDING …` frame clause to the window function.
public final WindowRowsAndStep<T>	rowsBetweenUnboundedFollowing() Implements org.jooq.WindowRowsStep.rowsBetweenUnboundedFollowing. Add a `ROWS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function.
public final WindowRowsAndStep<T>	rowsBetweenUnboundedPreceding() Implements org.jooq.WindowRowsStep.rowsBetweenUnboundedPreceding. Add a `ROWS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function.
public final WindowExcludeStep<T>	rowsCurrentRow() Implements org.jooq.WindowRowsStep.rowsCurrentRow. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS CURRENT ROW` frame clause to the window function.
public final WindowExcludeStep<T>	rowsFollowing(int number) Implements org.jooq.WindowRowsStep.rowsFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS [number] FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	rowsPreceding(int number) Implements org.jooq.WindowRowsStep.rowsPreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS [number] PRECEDING` frame clause to the window function.
public final WindowExcludeStep<T>	rowsUnboundedFollowing() Implements org.jooq.WindowRowsStep.rowsUnboundedFollowing. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS UNBOUNDED FOLLOWING` frame clause to the window function.
public final WindowExcludeStep<T>	rowsUnboundedPreceding() Implements org.jooq.WindowRowsStep.rowsUnboundedPreceding. Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS UNBOUNDED PRECEDING` frame clause to the window function.
pack-priv final QueryPart	window(Context<?> ctx)

Inherited from org.jooq.impl.AbstractField:: $alias $aliased abs accept acos add add as as as as asc ascii asin atan atan2 atan2 avg avgOver between between between between betweenSymmetric betweenSymmetric betweenSymmetric betweenSymmetric bitAnd bitAnd bitLength bitNand bitNand bitNor bitNor bitNot bitOr bitOr bitXNor bitXNor bitXor bitXor cast cast cast ceil changed charLength clauses coalesce coalesce coerce coerce coerce collate collate collate comment comment compare compare compare compare concat concat concat contains contains containsIgnoreCase containsIgnoreCase convert convert convert convertFrom convertFrom convertTo convertTo cos cosh cot coth count countDistinct countOver decode decode decode decode deg desc div div divide divide endsWith endsWith endsWithIgnoreCase endsWithIgnoreCase eq eq eq eq equal equal equal equal equalIgnoreCase equalIgnoreCase exp extract field firstValue floor from ge ge ge ge get getValue greaterOrEqual greaterOrEqual greaterOrEqual greaterOrEqual greaterThan greaterThan greaterThan greaterThan greatest greatest gt gt gt gt in in in in in isDistinctFrom isDistinctFrom isDistinctFrom isDocument isFalse isJson isNotDistinctFrom isNotDistinctFrom isNotDistinctFrom isNotDocument isNotJson isNotNull isNull isNullable isPossiblyNullable isTrue lag lag lag lag lastValue le le le le lead lead lead lead least least length lessOrEqual lessOrEqual lessOrEqual lessOrEqual lessThan lessThan lessThan lessThan like like like like like likeIgnoreCase likeIgnoreCase likeIgnoreCase likeIgnoreCase likeRegex likeRegex ln log lower lpad lpad lpad lpad lt lt lt lt ltrim max maxOver median min minOver minus minus mod mod modulo modulo mul mul multiply multiply ne ne ne ne neg notBetween notBetween notBetween notBetween notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notBetweenSymmetric notContains notContains notContainsIgnoreCase notContainsIgnoreCase notEqual notEqual notEqual notEqual notEqualIgnoreCase notEqualIgnoreCase notIn notIn notIn notIn notIn notLike notLike notLike notLike notLike notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeIgnoreCase notLikeRegex notLikeRegex notSimilarTo notSimilarTo notSimilarTo notSimilarTo notSimilarTo nullif nullif nullsFirst nullsLast nvl nvl nvl2 nvl2 octetLength original parenthesised plus plus position position pow pow power power projectionSize rad rem rem repeat repeat replace replace replace replace reset round round rpad rpad rpad rpad rtrim shl shl shr shr sign similarTo similarTo similarTo similarTo similarTo sin sinh sort sort sortAsc sortAsc sortDefault sortDesc sortDesc sqrt startsWith startsWith startsWithIgnoreCase startsWithIgnoreCase stddevPop stddevPopOver stddevSamp stddevSampOver sub sub substring substring substring substring subtract subtract sum sumOver tan tanh times times trim unaryMinus unaryPlus upper varPop varPopOver varSamp varSampOver

pack-priv abstract Class AbstractWindowFunction<T>

Field Summary

Constructor Summary

Method Summary