Module org.jooq
Package org.jooq

Interface GroupField

All Superinterfaces:
QueryPart, Serializable
All Known Subinterfaces:
AggregateFilterStep<T>, AggregateFunction<T>, ArrayAggOrderByStep<T>, CaseConditionStep<T>, CaseWhenStep<V,​T>, Field<T>, GroupConcatOrderByStep, GroupConcatSeparatorStep, JSONArrayAggNullStep<T>, JSONArrayAggOrderByStep<J>, JSONArrayAggReturningStep<T>, JSONArrayNullStep<T>, JSONArrayReturningStep<T>, JSONObjectAggNullStep<T>, JSONObjectAggReturningStep<T>, JSONObjectNullStep<T>, JSONObjectReturningStep<T>, JSONValueOnStep<J>, JSONValueReturningStep<T>, Param<T>, Parameter<T>, ParamOrVariable<T>, TableField<R,​T>, UDTField<R,​T>, Variable<T>, WindowBeforeOverStep<T>, WindowExcludeStep<T>, WindowFinalStep<T>, WindowOrderByStep<T>, WindowPartitionByStep<T>, WindowRowsStep<T>, XMLAggOrderByStep<T>
All Known Implementing Classes:
CustomField

public interface GroupField extends QueryPart
An expression to be used exclusively in GROUP BY clauses.

The SELECT .. GROUP BY clause accepts a variety of expressions, mostly ordinary Field expressions, but also some special expressions usable only in the GROUP BY clause, such as DSL.groupingSets(Field[][]).

Example:

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

 using(configuration)
    .select(ACTOR.LAST_NAME)
    .from(ACTOR)
    .groupBy(ACTOR.LAST_NAME) // GroupField reference here
    .fetch();
 

Instances can be created using DSL.groupingSets(Field[][]) and related methods, or by creating a subtype.

Author:
Lukas Eder