Top Fields Constructors Methods
org.jooq.impl

pack-priv abstract Class AbstractAggregateFunction<T>

extends AbstractWindowFunction<T>
implements AggregateFunction<T>, OrderedAggregateFunction<T>, ArrayAggOrderByStep<T>
Class Inheritance
All Implemented Interfaces
org.jooq.ArrayAggOrderByStep, org.jooq.AggregateFilterStep, org.jooq.WindowBeforeOverStep, org.jooq.Field, org.jooq.TableElement, org.jooq.Named, org.jooq.QueryPart, java.io.Serializable, org.jooq.FieldOrConstraint, org.jooq.FieldOrRowOrSelect, org.jooq.FieldOrRow, org.jooq.OrderField, org.jooq.GroupField, org.jooq.SelectField, org.jooq.Typed, org.jooq.SelectFieldOrAsterisk, org.jooq.WindowOverStep, org.jooq.OrderedAggregateFunction, org.jooq.AggregateFunction
Known Direct Subclasses
org.jooq.impl.BitAndAgg, org.jooq.impl.BitNandAgg, org.jooq.impl.BitNorAgg, org.jooq.impl.BitOrAgg, org.jooq.impl.BitXNorAgg, org.jooq.impl.BitXorAgg, org.jooq.impl.BoolAnd, org.jooq.impl.BoolOr, org.jooq.impl.AnyValue, org.jooq.impl.ArrayAgg, org.jooq.impl.Median, org.jooq.impl.Min, org.jooq.impl.Mode, org.jooq.impl.MultisetAgg, org.jooq.impl.Sum, org.jooq.impl.Corr, org.jooq.impl.VarPop, org.jooq.impl.Avg, org.jooq.impl.RatioToReport, org.jooq.impl.DefaultAggregateFunction, org.jooq.impl.JSONArrayAgg, org.jooq.impl.JSONObjectAgg, org.jooq.impl.StddevPop, org.jooq.impl.StddevSamp, org.jooq.impl.Count, org.jooq.impl.CountTable, org.jooq.impl.CovarPop, org.jooq.impl.CovarSamp, org.jooq.impl.RegrAvgX, org.jooq.impl.RegrAvgY, org.jooq.impl.RegrCount, org.jooq.impl.RegrIntercept, org.jooq.impl.RegrR2, org.jooq.impl.RegrSlope, org.jooq.impl.RegrSxx, org.jooq.impl.RegrSxy, org.jooq.impl.RegrSyy, org.jooq.impl.XMLAgg, org.jooq.impl.GroupConcat, org.jooq.impl.ListAgg, org.jooq.impl.Max, org.jooq.impl.Product, org.jooq.impl.VarSamp
Static Imports
java.util.function.Function.identity, org.jooq.SQLDialect.*, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB, org.jooq.impl.DSL.condition, .DSL.one, .DSL.zero, .Keywords.K_DENSE_RANK, .Keywords.K_DISTINCT, .Keywords.K_FILTER, .Keywords.K_FIRST, .Keywords.K_KEEP, .Keywords.K_LAST, .Keywords.K_NULL, .Keywords.K_ORDER_BY, .Keywords.K_WHERE, .Keywords.K_WITHIN_GROUP, .Names.N_COUNT, .Names.N_COUNTIF, .Names.N_COUNT_IF, .QueryPartCollectionView.wrap, .SQLDataType.DOUBLE, .SQLDataType.NUMERIC, .Tools.camelCase, .Tools.isEmpty

Deprecated

as a consequence of AbstractWindowFunction, AggregateFunction and ArrayAggOrderByStep being deprecated. See corresponding docs for further information.

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
pack-priv final QueryPartList<Field<?>>
pack-priv static final Lazy<Field<Integer>>
pack-priv final boolean
pack-priv final ConditionProviderImpl
filter

Deprecated as a consequence of ConditionProviderImpl being deprecated.
pack-priv boolean
pack-priv SortFieldList
pack-priv static final Set<SQLDialect>
pack-priv static final Set<SQLDialect>
pack-priv SortFieldList
Inherited from org.jooq.impl.AbstractWindowFunction:
fromFirstOrLastnullTreatmentwindowDefinitionwindowNamewindowSpecification

Constructor Summary

AccessConstructor and Description
pack-priv
AbstractAggregateFunction(String name, DataType<T> type, Field<?>... arguments)

Deprecated as a consequence of Field being deprecated.
pack-priv
AbstractAggregateFunction(Name name, DataType<T> type, Field<?>... arguments)

Deprecated as a consequence of Field being deprecated.
pack-priv
AbstractAggregateFunction(boolean distinct, String name, DataType<T> type, Field<?>... arguments)

Deprecated as a consequence of Field being deprecated.
pack-priv
AbstractAggregateFunction(boolean distinct, Name name, DataType<T> type, Field<?>... arguments)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final boolean
public final Condition
$filterWhere()

Implements org.jooq.AggregateFunction.$filterWhere.

Deprecated as a consequence of Condition being deprecated.
Experimental query object model accessor method, see also QOM.
public void
accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
pack-priv final void
pack-priv final void
pack-priv final void
pack-priv final void
acceptArguments3(Context<?> ctx, QueryPartCollectionView<Field<?>> args, Function<? super Field<?>, ? extends Field<?>> fun)

pack-priv final void
pack-priv static final void
acceptFilterClause(Context<?> ctx, Condition filter)

Deprecated as a consequence of Condition being deprecated.
pack-priv void
private final void
acceptKeepDenseRankOrderByClause(Context<?> ctx)

Render KEEP (DENSE_RANK [FIRST | LAST] ORDER BY {…}) clause

pack-priv final void
pack-priv final void
acceptWithinGroupClause(Context<?> ctx)

Render WITHIN GROUP (ORDER BY …) clause

pack-priv boolean
applyFilter(Context<?> ctx, Field<?> arg, int i)

Deprecated as a consequence of Field being deprecated.
pack-priv final DataType<? extends Number>
d(Context<?> ctx)

The data type to use in casts when emulating statistical functions.

pack-priv final Condition
f(Condition c)

Deprecated as a consequence of Condition being deprecated.
public final WindowBeforeOverStep<T>
filterWhere(Condition c)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of Condition and WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function, connecting conditions with each other with Operator#AND.
public final WindowBeforeOverStep<T>
filterWhere(Condition... conditions)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of Condition and WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function, connecting conditions with each other with Operator#AND.
public final WindowBeforeOverStep<T>
filterWhere(Collection<? extends Condition> conditions)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function, connecting conditions with each other with Operator#AND.
public final WindowBeforeOverStep<T>
filterWhere(Field<Boolean> field)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of Field and WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function.
public final WindowBeforeOverStep<T>
filterWhere(SQL sql)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function.
public final WindowBeforeOverStep<T>
filterWhere(String sql)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function.
public final WindowBeforeOverStep<T>
filterWhere(String sql, Object... bindings)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function.
public final WindowBeforeOverStep<T>
filterWhere(String sql, QueryPart... parts)

Implements org.jooq.AggregateFilterStep.filterWhere.

Deprecated as a consequence of WindowBeforeOverStep being deprecated.
Add a FILTER clause to the aggregate function.
pack-priv final <U> Field<U>
fo(AggregateFilterStep<U> function)

Deprecated as a consequence of AggregateFilterStep and Field being deprecated.
Apply this aggregate function's FILTER and OVER clauses to an argument aggregate function.
pack-priv final <U> Field<U>
fon(AggregateFunction<U> function)

Deprecated as a consequence of AggregateFunction and Field being deprecated.
pack-priv final QueryPartList<Field<?>>
pack-priv final <U> Field<U>
o(WindowBeforeOverStep<U> function)

Deprecated as a consequence of WindowBeforeOverStep and Field being deprecated.
Apply this aggregate function's FILTER and OVER clauses to an argument aggregate function.
pack-priv final <U> Field<U>
ofo(AbstractAggregateFunction<U> function)

Deprecated as a consequence of AbstractAggregateFunction and Field being deprecated.
Apply this aggregate function's ORDER BY, FILTER and OVER clauses to an argument aggregate function.
public AbstractAggregateFunction<T>
orderBy(OrderField<?>... fields)

Overrides org.jooq.impl.AbstractWindowFunction.orderBy.

Implements org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Deprecated as a consequence of AbstractAggregateFunction being deprecated.
Add an ORDER BY clause to the function.
public AbstractAggregateFunction<T>
orderBy(Collection<? extends OrderField<?>> fields)

Overrides org.jooq.impl.AbstractWindowFunction.orderBy.

Implements org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Deprecated as a consequence of AbstractAggregateFunction being deprecated.
Add an ORDER BY clause to the function.
private final void
toSQLArguments(Context<?> ctx)

Render function arguments and argument modifiers

public final AggregateFunction<T>
withinGroupOrderBy(OrderField<?>... fields)

Implements org.jooq.OrderedAggregateFunction.withinGroupOrderBy.

Deprecated as a consequence of AggregateFunction being deprecated.
Add an WITHIN GROUP (ORDER BY …) clause to the ordered aggregate function
public final AggregateFunction<T>
withinGroupOrderBy(Collection<? extends OrderField<?>> fields)

Implements org.jooq.OrderedAggregateFunction.withinGroupOrderBy.

Deprecated as a consequence of AggregateFunction being deprecated.
Add an WITHIN GROUP (ORDER BY …) clause to the ordered aggregate function
pack-priv final <U extends Number> Field<U>
x(Field<U> x, Field<? extends Number> y)

Deprecated as a consequence of Field being deprecated.
Type safe NVL2(y, x, null) for statistical function emulations.
pack-priv final <U extends Number> Field<U>
y(Field<? extends Number> x, Field<U> y)

Deprecated as a consequence of Field being deprecated.
Type safe NVL2(x, y, null) for statistical function emulations.
Inherited from org.jooq.impl.AbstractWindowFunction:
$fromFirstOrLast$fromFirstOrLast$nullTreatment$nullTreatment$windowDefinition$windowDefinition$windowSpecification$windowSpecificationacceptFromFirstOrLastacceptNullTreatmentacceptNullTreatmentStandardacceptOverClauseandCurrentRowandFollowingandPrecedingandUnboundedFollowingandUnboundedPrecedingexcludeCurrentRowexcludeGroupexcludeNoOthersexcludeTiesfromFirstfromLastgroupsBetweenCurrentRowgroupsBetweenFollowinggroupsBetweenPrecedinggroupsBetweenUnboundedFollowinggroupsBetweenUnboundedPrecedinggroupsCurrentRowgroupsFollowinggroupsPrecedinggroupsUnboundedFollowinggroupsUnboundedPrecedingignoreNullsisWindowoveroveroveroveroverpartitionBypartitionBypartitionByOnerangeBetweenCurrentRowrangeBetweenFollowingrangeBetweenPrecedingrangeBetweenUnboundedFollowingrangeBetweenUnboundedPrecedingrangeCurrentRowrangeFollowingrangePrecedingrangeUnboundedFollowingrangeUnboundedPrecedingrespectNullsrowsBetweenCurrentRowrowsBetweenFollowingrowsBetweenPrecedingrowsBetweenUnboundedFollowingrowsBetweenUnboundedPrecedingrowsCurrentRowrowsFollowingrowsPrecedingrowsUnboundedFollowingrowsUnboundedPrecedingwindow

Field Detail

argumentsback to summary
pack-priv final QueryPartList<Field<?>> arguments
ASTERISKback to summary
pack-priv static final Lazy<Field<Integer>> ASTERISK
distinctback to summary
pack-priv final boolean distinct
filterback to summary
pack-priv final ConditionProviderImpl filter

Deprecated

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

firstback to summary
pack-priv boolean first
keepDenseRankOrderByback to summary
pack-priv SortFieldList keepDenseRankOrderBy
NO_SUPPORT_FILTERback to summary
pack-priv static final Set<SQLDialect> NO_SUPPORT_FILTER
SUPPORT_DISTINCT_RVEback to summary
pack-priv static final Set<SQLDialect> SUPPORT_DISTINCT_RVE
withinGroupOrderByback to summary
pack-priv SortFieldList withinGroupOrderBy

Constructor Detail

AbstractAggregateFunctionback to summary
pack-priv AbstractAggregateFunction(String name, DataType<T> type, Field<?>... arguments)

Deprecated

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

AbstractAggregateFunctionback to summary
pack-priv AbstractAggregateFunction(Name name, DataType<T> type, Field<?>... arguments)

Deprecated

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

AbstractAggregateFunctionback to summary
pack-priv AbstractAggregateFunction(boolean distinct, String name, DataType<T> type, Field<?>... arguments)

Deprecated

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

AbstractAggregateFunctionback to summary
pack-priv AbstractAggregateFunction(boolean distinct, Name name, DataType<T> type, Field<?>... arguments)

Deprecated

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

Method Detail

$distinctback to summary
public final boolean $distinct()
$filterWhereback to summary
public final Condition $filterWhere()

Implements org.jooq.AggregateFunction.$filterWhere.

Doc from org.jooq.AggregateFunction.$filterWhere.

Deprecated

as a consequence of Condition 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
acceptback to summary
public void accept(Context<?> ctx)

Implements abstract org.jooq.impl.AbstractField.accept.

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
acceptArguments0back to summary
pack-priv final void acceptArguments0(Context<?> ctx)
acceptArguments1back to summary
pack-priv final void acceptArguments1(Context<?> ctx, QueryPartCollectionView<Field<?>> args)
acceptArguments2back to summary
pack-priv final void acceptArguments2(Context<?> ctx, QueryPartCollectionView<Field<?>> args)
acceptArguments3back to summary
pack-priv final void acceptArguments3(Context<?> ctx, QueryPartCollectionView<Field<?>> args, Function<? super Field<?>, ? extends Field<?>> fun)
acceptFilterClauseback to summary
pack-priv final void acceptFilterClause(Context<?> ctx)
acceptFilterClauseback to summary
pack-priv static final void acceptFilterClause(Context<?> ctx, Condition filter)

Deprecated

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

acceptFunctionNameback to summary
pack-priv void acceptFunctionName(Context<?> ctx)
acceptKeepDenseRankOrderByClauseback to summary
private final void acceptKeepDenseRankOrderByClause(Context<?> ctx)

Render KEEP (DENSE_RANK [FIRST | LAST] ORDER BY {…}) clause

acceptOrderByback to summary
pack-priv final void acceptOrderBy(Context<?> ctx)
acceptWithinGroupClauseback to summary
pack-priv final void acceptWithinGroupClause(Context<?> ctx)

Render WITHIN GROUP (ORDER BY …) clause

applyFilterback to summary
pack-priv boolean applyFilter(Context<?> ctx, Field<?> arg, int i)

Deprecated

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

dback to summary
pack-priv final DataType<? extends Number> d(Context<?> ctx)

The data type to use in casts when emulating statistical functions.

fback to summary
pack-priv final Condition f(Condition c)

Deprecated

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

filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(Condition c)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

as a consequence of Condition and WindowBeforeOverStep being deprecated. See corresponding docs for further information.

Add a FILTER clause to the aggregate function, connecting conditions with each other with Operator#AND.

Annotations
@Override
filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(Condition... conditions)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

as a consequence of Condition and WindowBeforeOverStep being deprecated. See corresponding docs for further information.

Add a FILTER clause to the aggregate function, connecting conditions with each other with Operator#AND.

Annotations
@Override
filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(Collection<? extends Condition> conditions)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

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

Add a FILTER clause to the aggregate function, connecting conditions with each other with Operator#AND.

Annotations
@Override
filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(Field<Boolean> field)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

as a consequence of Field and WindowBeforeOverStep being deprecated. See corresponding docs for further information.

Add a FILTER clause to the aggregate function.

Annotations
@Override
filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(SQL sql)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

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

Add a FILTER clause to the aggregate function.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Override
filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(String sql)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

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

Add a FILTER clause to the aggregate function.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Override
filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(String sql, Object... bindings)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

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

Add a FILTER clause to the aggregate function.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Override
filterWhereback to summary
public final WindowBeforeOverStep<T> filterWhere(String sql, QueryPart... parts)

Implements org.jooq.AggregateFilterStep.filterWhere.

Doc from org.jooq.AggregateFilterStep.filterWhere.

Deprecated

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

Add a FILTER clause to the aggregate function.

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Annotations
@Override
foback to summary
pack-priv final <U> Field<U> fo(AggregateFilterStep<U> function)

Deprecated

as a consequence of AggregateFilterStep and Field being deprecated. See corresponding docs for further information.

Apply this aggregate function's FILTER and OVER clauses to an argument aggregate function.

fonback to summary
pack-priv final <U> Field<U> fon(AggregateFunction<U> function)

Deprecated

as a consequence of AggregateFunction and Field being deprecated. See corresponding docs for further information.

Annotations
@SuppressWarnings:unchecked
getArgumentsback to summary
pack-priv final QueryPartList<Field<?>> getArguments()
oback to summary
pack-priv final <U> Field<U> o(WindowBeforeOverStep<U> function)

Deprecated

as a consequence of WindowBeforeOverStep and Field being deprecated. See corresponding docs for further information.

Apply this aggregate function's FILTER and OVER clauses to an argument aggregate function.

ofoback to summary
pack-priv final <U> Field<U> ofo(AbstractAggregateFunction<U> function)

Deprecated

as a consequence of AbstractAggregateFunction and Field being deprecated. See corresponding docs for further information.

Apply this aggregate function's ORDER BY, FILTER and OVER clauses to an argument aggregate function.

orderByback to summary
public AbstractAggregateFunction<T> orderBy(OrderField<?>... fields)

Overrides org.jooq.impl.AbstractWindowFunction.orderBy.

Implements org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Doc from org.jooq.ArrayAggOrderByStep.orderBy.

Deprecated

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

Add an ORDER BY clause to the function.

Annotations
@Override
orderByback to summary
public AbstractAggregateFunction<T> orderBy(Collection<? extends OrderField<?>> fields)

Overrides org.jooq.impl.AbstractWindowFunction.orderBy.

Implements org.jooq.ArrayAggOrderByStep.orderBy, org.jooq.WindowOrderByStep.orderBy.

Doc from org.jooq.ArrayAggOrderByStep.orderBy.

Deprecated

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

Add an ORDER BY clause to the function.

Annotations
@Override
toSQLArgumentsback to summary
private final void toSQLArguments(Context<?> ctx)

Render function arguments and argument modifiers

withinGroupOrderByback to summary
public final AggregateFunction<T> withinGroupOrderBy(OrderField<?>... fields)

Implements org.jooq.OrderedAggregateFunction.withinGroupOrderBy.

Doc from org.jooq.OrderedAggregateFunction.withinGroupOrderBy.

Deprecated

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

Add an WITHIN GROUP (ORDER BY …) clause to the ordered aggregate function

Annotations
@Override
withinGroupOrderByback to summary
public final AggregateFunction<T> withinGroupOrderBy(Collection<? extends OrderField<?>> fields)

Implements org.jooq.OrderedAggregateFunction.withinGroupOrderBy.

Doc from org.jooq.OrderedAggregateFunction.withinGroupOrderBy.

Deprecated

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

Add an WITHIN GROUP (ORDER BY …) clause to the ordered aggregate function

Annotations
@Override
xback to summary
pack-priv final <U extends Number> Field<U> x(Field<U> x, Field<? extends Number> y)

Deprecated

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

Type safe NVL2(y, x, null) for statistical function emulations.

yback to summary
pack-priv final <U extends Number> Field<U> y(Field<? extends Number> x, Field<U> y)

Deprecated

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

Type safe NVL2(x, y, null) for statistical function emulations.