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 and 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 and Description
AggregateFunction<java.lang.String>	GroupConcatSeparatorStep.separator(java.lang.String separator) Specify the separator on the GROUP_CONCAT function
AggregateFunction<T>	OrderedAggregateFunction.withinGroupOrderBy(java.util.Collection<? extends SortField<?>> fields) Add an WITHIN GROUP (ORDER BY ..)
AggregateFunction<T>	OrderedAggregateFunction.withinGroupOrderBy(Field<?>... fields) Add an WITHIN GROUP (ORDER BY ..)
AggregateFunction<T>	OrderedAggregateFunction.withinGroupOrderBy(SortField<?>... fields) Add an WITHIN GROUP (ORDER BY ..)

Uses of AggregateFunction in org.jooq.impl

Methods in org.jooq.impl that return AggregateFunction

Modifier and Type	Method and Description
AggregateFunction<T>	AbstractRoutine.asAggregateFunction()
static AggregateFunction<java.math.BigDecimal>	DSL.avg(Field<? extends java.lang.Number> field) Get the average over a numeric field: avg(field).
static AggregateFunction<java.math.BigDecimal>	DSL.avgDistinct(Field<? extends java.lang.Number> field) Get the average over a numeric field: avg(distinct field).
static AggregateFunction<java.lang.Integer>	DSL.count() Get the count(*) function.
static AggregateFunction<java.lang.Integer>	DSL.count(Field<?> field) Get the count(field) function.
static AggregateFunction<java.lang.Integer>	DSL.count(Table<?> table) Get the count(table) function.
static AggregateFunction<java.lang.Integer>	DSL.countDistinct(Field<?>... fields) Get the count(distinct field1, field2) function.
static AggregateFunction<java.lang.Integer>	DSL.countDistinct(Field<?> field) Get the count(distinct field) function.
static AggregateFunction<java.lang.Integer>	DSL.countDistinct(Table<?> table) Get the count(distinct table) function.
static AggregateFunction<java.lang.String>	DSL.groupConcat(Field<?> field, java.lang.String separator) Get the aggregated concatenation for a field.
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<java.math.BigDecimal>	DSL.median(Field<? extends java.lang.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 AggregateFunction<java.math.BigDecimal>	DSL.regrAvgX(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_AVGX linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrAvgY(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_AVGY linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrCount(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_COUNT linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrIntercept(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_INTERCEPT linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrR2(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_R2 linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrSlope(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_SLOPE linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrSXX(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_SXX linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrSXY(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_SXY linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.regrSYY(Field<? extends java.lang.Number> y, Field<? extends java.lang.Number> x) Get the REGR_SYY linear regression function.
static AggregateFunction<java.math.BigDecimal>	DSL.stddevPop(Field<? extends java.lang.Number> field) Get the population standard deviation of a numeric field: stddev_pop(field).
static AggregateFunction<java.math.BigDecimal>	DSL.stddevSamp(Field<? extends java.lang.Number> field) Get the sample standard deviation of a numeric field: stddev_samp(field).
static AggregateFunction<java.math.BigDecimal>	DSL.sum(Field<? extends java.lang.Number> field) Get the sum over a numeric field: sum(field).
static AggregateFunction<java.math.BigDecimal>	DSL.sumDistinct(Field<? extends java.lang.Number> field) Get the sum over a numeric field: sum(distinct field).
static AggregateFunction<java.math.BigDecimal>	DSL.varPop(Field<? extends java.lang.Number> field) Get the population variance of a numeric field: var_pop(field).
static AggregateFunction<java.math.BigDecimal>	DSL.varSamp(Field<? extends java.lang.Number> field) Get the sample variance of a numeric field: var_samp(field).