-
- 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>
,JSONArrayNullStep<T>
,JSONObjectAggNullStep<T>
,JSONObjectNullStep<T>
,JSONValueOnStep<J>
,Param<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 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