Uses of Interface
org.jooq.AggregateFunction

Packages that use AggregateFunction

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API This package mostly contains interfaces that are implemented by the org.jooq.impl package.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes This package provides implementations for the jOOQ API from org.jooq, whose interfaces are constructed mostly through the Factory class, which hides implementation facts from the public API

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<String>	GroupConcatSeparatorStep.separator(String separator) Specify the separator on the GROUP_CONCAT function
AggregateFunction<T>	OrderedAggregateFunction.withinGroupOrderBy(Collection<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<BigDecimal>	Factory.avg(Field<? extends Number> field) Get the average over a numeric field: avg(field)
static AggregateFunction<BigDecimal>	Factory.avgDistinct(Field<? extends Number> field) Get the average over a numeric field: avg(distinct field)
static AggregateFunction<Integer>	Factory.count() Get the count(*) function
static AggregateFunction<Integer>	Factory.count(Field<?> field) Get the count(field) function
static AggregateFunction<Integer>	Factory.countDistinct(Field<?>... fields) Get the count(distinct field1, field2) function Some dialects support several expressions in the COUNT(DISTINCT expr1, expr2) aggregate function.
static AggregateFunction<Integer>	Factory.countDistinct(Field<?> field) Get the count(distinct field) function
static <T> AggregateFunction<T>	Factory.max(Field<T> field) Get the max value over a field: max(field)
static <T> AggregateFunction<T>	Factory.maxDistinct(Field<T> field) Get the max value over a field: max(distinct field)
static AggregateFunction<BigDecimal>	Factory.median(Field<? extends Number> field) Get the median over a numeric field: median(field)
static <T> AggregateFunction<T>	Factory.min(Field<T> field) Get the min value over a field: min(field)
static <T> AggregateFunction<T>	Factory.minDistinct(Field<T> field) Get the min value over a field: min(distinct field)
static AggregateFunction<BigDecimal>	Factory.regrAvgX(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_AVGX linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrAvgY(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_AVGY linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrCount(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_COUNT linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrIntercept(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_INTERCEPT linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrR2(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_R2 linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrSlope(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_SLOPE linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrSXX(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_SXX linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrSXY(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_SXY linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.regrSYY(Field<? extends Number> y, Field<? extends Number> x) Get the REGR_SYY linear regression function The linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
static AggregateFunction<BigDecimal>	Factory.stddevPop(Field<? extends Number> field) Get the population standard deviation of a numeric field: stddev_pop(field)
static AggregateFunction<BigDecimal>	Factory.stddevSamp(Field<? extends Number> field) Get the sample standard deviation of a numeric field: stddev_samp(field)
static AggregateFunction<BigDecimal>	Factory.sum(Field<? extends Number> field) Get the sum over a numeric field: sum(field)
static AggregateFunction<BigDecimal>	Factory.sumDistinct(Field<? extends Number> field) Get the sum over a numeric field: sum(distinct field)
static AggregateFunction<BigDecimal>	Factory.varPop(Field<? extends Number> field) Get the population variance of a numeric field: var_pop(field)
static AggregateFunction<BigDecimal>	Factory.varSamp(Field<? extends Number> field) Get the sample variance of a numeric field: var_samp(field)