Uses of Interface
org.jooq.AggregateFunction

Packages that use AggregateFunction

org.jooq
org.jooq.impl

Uses of AggregateFunction in org.jooq

Subinterfaces of AggregateFunction in org.jooq

interface	GroupConcatOrderByStep MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep MySQL's GROUP_CONCAT function.

Methods in org.jooq that return AggregateFunction

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

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<?> 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) This is known to be supported in any of these RDBMS: HSQLDB Oracle Sybase SQL Anywhere
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.stddevPop(Field<? extends Number> field) Get the population standard deviation of a numeric field: stddev_pop(field) This is known to be supported in any of these RDBMS: DB2 H2 HSQLDB Ingres MySQL Oracle Postgres SQL Server (stdev) Sybase ASE Sybase SQL Anywhere
static AggregateFunction<BigDecimal>	Factory.stddevSamp(Field<? extends Number> field) Get the sample standard deviation of a numeric field: stddev_samp(field) This is known to be supported in any of these RDBMS: DB2 H2 HSQLDB Ingres MySQL Oracle Postgres SQL Server (stdev) Sybase ASE Sybase SQL Anywhere
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) This is known to be supported in any of these RDBMS: DB2 H2 HSQLDB Ingres MySQL Oracle Postgres SQL Server (stdev) Sybase ASE Sybase SQL Anywhere
static AggregateFunction<BigDecimal>	Factory.varSamp(Field<? extends Number> field) Get the sample variance of a numeric field: var_samp(field) This is known to be supported in any of these RDBMS: H2 HSQLDB Ingres MySQL Oracle Postgres SQL Server (var) Sybase SQL Anywhere