Uses of Interface
org.jooq.AggregateFunction

Packages that use AggregateFunction

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of AggregateFunction in org.jooq

Subinterfaces of AggregateFunction in org.jooq

Modifier and Type	Interface	Description
interface	GroupConcatOrderByStep	MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep	MySQL's GROUP_CONCAT function.

Methods in org.jooq that return AggregateFunction

Modifier and Type	Method	Description
@NotNull AggregateFunction<String>	GroupConcatSeparatorStep.separator(String separator)	Specify the separator on the GROUP_CONCAT function.
@NotNull AggregateFunction<String>	GroupConcatSeparatorStep.separator(Field<String> separator)	Specify the separator on the GROUP_CONCAT function.

Uses of AggregateFunction in org.jooq.impl

Subinterfaces of AggregateFunction in org.jooq.impl

Modifier and Type	Interface	Description
static interface	QOM.AnyValue<T>	The ANY VALUE function.
static interface	QOM.ArrayAgg<T>
static interface	QOM.Avg	The AVG function.
static interface	QOM.BitAndAgg<T extends Number>	The BIT AND AGG function.
static interface	QOM.BitNandAgg<T extends Number>	The BIT NAND AGG function.
static interface	QOM.BitNorAgg<T extends Number>	The BIT NOR AGG function.
static interface	QOM.BitOrAgg<T extends Number>	The BIT OR AGG function.
static interface	QOM.BitXNorAgg<T extends Number>	The BIT X NOR AGG function.
static interface	QOM.BitXorAgg<T extends Number>	The BIT XOR AGG function.
static interface	QOM.BoolAnd	The BOOL AND function.
static interface	QOM.BoolOr	The BOOL OR function.
static interface	QOM.Collect<T,A extends ArrayRecord<T>>
static interface	QOM.Corr	The CORR function.
static interface	QOM.Count	The COUNT function.
static interface	QOM.CountTable
static interface	QOM.CovarPop	The COVAR POP function.
static interface	QOM.CovarSamp	The COVAR SAMP function.
static interface	QOM.JSONArrayAgg<J>
static interface	QOM.JSONObjectAgg<J>
static interface	QOM.Max<T>	The MAX function.
static interface	QOM.Median	The MEDIAN function.
static interface	QOM.Min<T>	The MIN function.
static interface	QOM.Mode<T>
static interface	QOM.MultisetAgg<R extends Record>
static interface	QOM.Product	The PRODUCT function.
static interface	QOM.RatioToReport
static interface	QOM.RegrAvgX	The REGR AVGX function.
static interface	QOM.RegrAvgY	The REGR AVGY function.
static interface	QOM.RegrCount	The REGR COUNT function.
static interface	QOM.RegrIntercept	The REGR INTERCEPT function.
static interface	QOM.RegrR2	The REGR R2 function.
static interface	QOM.RegrSlope	The REGR SLOPE function.
static interface	QOM.RegrSxx	The REGR SXX function.
static interface	QOM.RegrSxy	The REGR SXY function.
static interface	QOM.RegrSyy	The REGR SYY function.
static interface	QOM.StddevPop	The STDDEV POP function.
static interface	QOM.StddevSamp	The STDDEV SAMP function.
static interface	QOM.Sum	The SUM function.
static interface	QOM.VarPop	The VAR POP function.
static interface	QOM.VarSamp	The VAR SAMP function.
static interface	QOM.XMLAgg

Methods in org.jooq.impl that return AggregateFunction

Modifier and Type	Method	Description
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(String name, Class<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(String name, DataType<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(Name name, Class<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregate(Name name, DataType<T> type, Field<?>... arguments)	aggregate() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(String name, Class<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(String name, DataType<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(Name name, Class<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.aggregateDistinct(Name name, DataType<T> type, Field<?>... arguments)	aggregateDistinct() can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.
static <T> @NotNull AggregateFunction<T>	DSL.anyValue(Field<T> field)	The ANY_VALUE function.
final AggregateFunction<T>	AbstractRoutine.asAggregateFunction()
static @NotNull AggregateFunction<BigDecimal>	DSL.avg(Field<? extends Number> field)	The AVG function.
static @NotNull AggregateFunction<BigDecimal>	DSL.avgDistinct(Field<? extends Number> field)	The AVG_DISTINCT function.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitAndAgg(Field<T> value)	The BIT_AND_AGG function.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitNandAgg(Field<T> value)	The BIT_NAND_AGG function.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitNorAgg(Field<T> value)	The BIT_NOR_AGG function.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitOrAgg(Field<T> value)	The BIT_OR_AGG function.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitXNorAgg(Field<T> value)	The BIT_XNOR_AGG function.
static <T extends Number> @NotNull AggregateFunction<T>	DSL.bitXorAgg(Field<T> value)	The BIT_XOR_AGG function.
static @NotNull AggregateFunction<Boolean>	DSL.boolAnd(Condition condition)	The BOOL_AND function.
static @NotNull AggregateFunction<Boolean>	DSL.boolAnd(Field<Boolean> condition)	The BOOL_AND function.
static @NotNull AggregateFunction<Boolean>	DSL.boolOr(Condition condition)	The BOOL_OR function.
static @NotNull AggregateFunction<Boolean>	DSL.boolOr(Field<Boolean> condition)	The BOOL_OR function.
static @NotNull AggregateFunction<BigDecimal>	DSL.corr(Field<? extends Number> y, Field<? extends Number> x)	The CORR function.
static @NotNull AggregateFunction<Integer>	DSL.count()	Get the count(*) function.
static @NotNull AggregateFunction<Integer>	DSL.count(Field<?> field)	The COUNT function.
static @NotNull AggregateFunction<Integer>	DSL.count(SelectFieldOrAsterisk field)	Get the count(field) function.
static @NotNull AggregateFunction<Integer>	DSL.count(Table<?> table)	Get the count(table) function.
static @NotNull AggregateFunction<Integer>	DSL.countDistinct(Field<?> field)	The COUNT_DISTINCT function.
static @NotNull AggregateFunction<Integer>	DSL.countDistinct(Field<?>... fields)	Get the count(distinct field1, field2) function.
static @NotNull AggregateFunction<Integer>	DSL.countDistinct(SelectFieldOrAsterisk field)	Get the count(distinct field) function.
static @NotNull AggregateFunction<Integer>	DSL.countDistinct(Table<?> table)	Get the count(distinct table) function.
static @NotNull AggregateFunction<BigDecimal>	DSL.covarPop(Field<? extends Number> y, Field<? extends Number> x)	The COVAR_POP function.
static @NotNull AggregateFunction<BigDecimal>	DSL.covarSamp(Field<? extends Number> y, Field<? extends Number> x)	The COVAR_SAMP function.
static @NotNull AggregateFunction<Boolean>	DSL.every(Condition condition)	The EVERY function, an alias for the BOOL_AND function.
static @NotNull AggregateFunction<Boolean>	DSL.every(Field<Boolean> condition)	The EVERY function, an alias for the BOOL_AND function.
static @NotNull AggregateFunction<String>	DSL.groupConcat(Field<?> field, String separator)	Deprecated, for removal: This API element is subject to removal in a future version. - [#7956] - 3.12.0 - Use DSL.groupConcat(Field) and GroupConcatSeparatorStep.separator(String) instead.
static <T> @NotNull AggregateFunction<T>	DSL.max(Field<T> field)	The MAX function.
static <T> @NotNull AggregateFunction<T>	DSL.maxDistinct(Field<T> field)	The MAX_DISTINCT function.
static @NotNull AggregateFunction<BigDecimal>	DSL.median(Field<? extends Number> field)	The MEDIAN function.
static <T> @NotNull AggregateFunction<T>	DSL.min(Field<T> field)	The MIN function.
static <T> @NotNull AggregateFunction<T>	DSL.minDistinct(Field<T> field)	The MIN_DISTINCT function.
static <T> @NotNull AggregateFunction<T>	DSL.mode(Field<T> field)	The mode(field) aggregate function.
static @NotNull AggregateFunction<BigDecimal>	DSL.product(Field<? extends Number> field)	The PRODUCT function.
static @NotNull AggregateFunction<BigDecimal>	DSL.productDistinct(Field<? extends Number> field)	The PRODUCT_DISTINCT function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrAvgX(Field<? extends Number> y, Field<? extends Number> x)	The REGR_AVGX function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrAvgY(Field<? extends Number> y, Field<? extends Number> x)	The REGR_AVGY function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrCount(Field<? extends Number> y, Field<? extends Number> x)	The REGR_COUNT function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrIntercept(Field<? extends Number> y, Field<? extends Number> x)	The REGR_INTERCEPT function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrR2(Field<? extends Number> y, Field<? extends Number> x)	The REGR_R2 function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrSlope(Field<? extends Number> y, Field<? extends Number> x)	The REGR_SLOPE function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrSXX(Field<? extends Number> y, Field<? extends Number> x)	The REGR_SXX function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrSXY(Field<? extends Number> y, Field<? extends Number> x)	The REGR_SXY function.
static @NotNull AggregateFunction<BigDecimal>	DSL.regrSYY(Field<? extends Number> y, Field<? extends Number> x)	The REGR_SYY function.
static @NotNull AggregateFunction<BigDecimal>	DSL.stddevPop(Field<? extends Number> field)	The STDDEV_POP function.
static @NotNull AggregateFunction<BigDecimal>	DSL.stddevSamp(Field<? extends Number> field)	The STDDEV_SAMP function.
static @NotNull AggregateFunction<BigDecimal>	DSL.sum(Field<? extends Number> field)	The SUM function.
static @NotNull AggregateFunction<BigDecimal>	DSL.sumDistinct(Field<? extends Number> field)	The SUM_DISTINCT function.
static @NotNull AggregateFunction<BigDecimal>	DSL.varPop(Field<? extends Number> field)	The VAR_POP function.
static @NotNull AggregateFunction<BigDecimal>	DSL.varSamp(Field<? extends Number> field)	The VAR_SAMP function.