-
- All Superinterfaces:
QueryPart
,Serializable
- All Known Subinterfaces:
AggregateFilterStep<T>
,AggregateFunction<T>
,ArrayAggOrderByStep<T>
,CaseConditionStep<T>
,CaseWhenStep<V,T>
,Field<T>
,GroupConcatOrderByStep
,GroupConcatSeparatorStep
,Param<T>
,TableField<R,T>
,UDTField<R,T>
,Variable<T>
,WindowBeforeOverStep<T>
,WindowExcludeStep<T>
,WindowFinalStep<T>
,WindowOrderByStep<T>
,WindowPartitionByStep<T>
,WindowRowsStep<T>
- All Known Implementing Classes:
ConvertDateTime
,CustomField
public interface GroupField extends QueryPart
An expression to be used exclusively inGROUP BY
clauses.The
SELECT .. GROUP BY
clause accepts a variety of expressions, mostly ordinaryField
expressions, but also some special expressions usable only in theGROUP BY
clause, such asDSL.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