Uses of Interface
org.jooq.AggregateFunction

Packages that use AggregateFunction

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.
org.jooq.impl	The org.jooq.impl 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
AggregateFunction<String>	GroupConcatSeparatorStep.separator(String separator)	Specify the separator on the GROUP_CONCAT function.

Uses of AggregateFunction in org.jooq.impl

Methods in org.jooq.impl that return AggregateFunction

Modifier and Type	Method	Description
AggregateFunction<T>	AbstractRoutine.asAggregateFunction()
static AggregateFunction<BigDecimal>	DSL.avg(Field<? extends Number> field)	Get the average over a numeric field: avg(field).
static AggregateFunction<BigDecimal>	DSL.avgDistinct(Field<? extends Number> field)	Get the average over a numeric field: avg(distinct field).
static AggregateFunction<Boolean>	DSL.boolAnd(Condition condition)	Get the every value over a condition: bool_and(condition).
static AggregateFunction<Boolean>	DSL.boolAnd(Field<Boolean> field)	Get the every value over a field: bool_and(field).
static AggregateFunction<Boolean>	DSL.boolOr(Condition condition)	Get the every value over a condition: bool_and(condition).
static AggregateFunction<Boolean>	DSL.boolOr(Field<Boolean> field)	Get the every value over a field: bool_and(field).
static AggregateFunction<Integer>	DSL.count()	Get the count(*) function.
static AggregateFunction<Integer>	DSL.count(Field<?> field)	Get the count(field) function.
static AggregateFunction<Integer>	DSL.count(SelectFieldOrAsterisk field)	Get the count(field) function.
static AggregateFunction<Integer>	DSL.count(Table<?> table)	Get the count(table) function.
static AggregateFunction<Integer>	DSL.countDistinct(Field<?> field)	Get the count(distinct field) function.
static AggregateFunction<Integer>	DSL.countDistinct(Field<?>... fields)	Get the count(distinct field1, field2) function.
static AggregateFunction<Integer>	DSL.countDistinct(SelectFieldOrAsterisk field)	Get the count(distinct field) function.
static AggregateFunction<Integer>	DSL.countDistinct(Table<?> table)	Get the count(distinct table) function.
static AggregateFunction<Boolean>	DSL.every(Condition condition)	Get the every value over a condition: every(condition).
static AggregateFunction<Boolean>	DSL.every(Field<Boolean> field)	Get the every value over a field: every(field).
static AggregateFunction<String>	DSL.groupConcat(Field<?> field, String separator)	Deprecated. - [#7956] - 3.12.0 - Use DSL.groupConcat(Field) and GroupConcatSeparatorStep.separator(String) instead.
static <T> AggregateFunction<T>	DSL.max(Field<T> field)	Get the max value over a field: max(field).
static <T> AggregateFunction<T>	DSL.maxDistinct(Field<T> field)	Get the max value over a field: max(distinct field).
static AggregateFunction<BigDecimal>	DSL.median(Field<? extends Number> field)	Get the median over a numeric field: median(field).
static <T> AggregateFunction<T>	DSL.min(Field<T> field)	Get the min value over a field: min(field).
static <T> AggregateFunction<T>	DSL.minDistinct(Field<T> field)	Get the min value over a field: min(distinct field).
static <T> AggregateFunction<T>	DSL.mode(Field<T> field)	The mode(field) aggregate function.
static AggregateFunction<BigDecimal>	DSL.product(Field<? extends Number> field)	Get the product over a numeric field: product(field).
static AggregateFunction<BigDecimal>	DSL.productDistinct(Field<? extends Number> field)	Get the sum over a numeric field: product(distinct field).
static AggregateFunction<BigDecimal>	DSL.regrAvgX(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_AVGX linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrAvgY(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_AVGY linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrCount(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_COUNT linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrIntercept(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_INTERCEPT linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrR2(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_R2 linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrSlope(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_SLOPE linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrSXX(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_SXX linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrSXY(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_SXY linear regression function.
static AggregateFunction<BigDecimal>	DSL.regrSYY(Field<? extends Number> y, Field<? extends Number> x)	Get the REGR_SYY linear regression function.
static AggregateFunction<BigDecimal>	DSL.stddevPop(Field<? extends Number> field)	Get the population standard deviation of a numeric field: stddev_pop(field).
static AggregateFunction<BigDecimal>	DSL.stddevSamp(Field<? extends Number> field)	Get the sample standard deviation of a numeric field: stddev_samp(field).
static AggregateFunction<BigDecimal>	DSL.sum(Field<? extends Number> field)	Get the sum over a numeric field: sum(field).
static AggregateFunction<BigDecimal>	DSL.sumDistinct(Field<? extends Number> field)	Get the sum over a numeric field: sum(distinct field).
static AggregateFunction<BigDecimal>	DSL.varPop(Field<? extends Number> field)	Get the population variance of a numeric field: var_pop(field).
static AggregateFunction<BigDecimal>	DSL.varSamp(Field<? extends Number> field)	Get the sample variance of a numeric field: var_samp(field).