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

Method Summary

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString