public Interface AggregateFunction<T>

An aggregate function is a special field that is usually used in a GROUP BY context. It is also the base for window function construction.

Example:

// Assuming import static org.jooq.impl.DSL.*;

using(configuration)
   .select(ACTOR.LAST_NAME, count())
   .from(ACTOR)
   .groupBy(ACTOR.LAST_NAME)
   .orderBy(count().desc())
   .fetch();

Instances can be created using various DSL methods and their overloads, such as DSL#count() or DSL#countDistinct(Field).