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
 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<?> 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
 



Copyright © 2012. All Rights Reserved.