Uses of Interface
org.jooq.AggregateFilterStep

Packages that use AggregateFilterStep

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.

Uses of AggregateFilterStep in org.jooq

Subinterfaces of AggregateFilterStep in org.jooq

Modifier and Type	Interface and Description
interface	AggregateFunction<T> An aggregate function is a special field that is usually used in a GROUP BY context.
interface	ArrayAggOrderByStep<T> The SQL standard ARRAY_AGG() function.
interface	GroupConcatOrderByStep MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep MySQL's GROUP_CONCAT function.

Methods in org.jooq that return AggregateFilterStep

Modifier and Type	Method and Description
AggregateFilterStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(java.util.Collection<? extends SortField<?>> fields) Restrict this aggregate function to FIRST values An example: MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
AggregateFilterStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(Field<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
AggregateFilterStep<T>	AggregateFunction.keepDenseRankFirstOrderBy(SortField<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(id) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
AggregateFilterStep<T>	AggregateFunction.keepDenseRankLastOrderBy(java.util.Collection<? extends SortField<?>> fields) Restrict this aggregate function to FIRST values An example: MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
AggregateFilterStep<T>	AggregateFunction.keepDenseRankLastOrderBy(Field<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
AggregateFilterStep<T>	AggregateFunction.keepDenseRankLastOrderBy(SortField<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(id) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
AggregateFilterStep<T>	ArrayAggOrderByStep.orderBy(java.util.Collection<? extends SortField<?>> fields) Add an ORDER BY clause to the function.
AggregateFilterStep<T>	ArrayAggOrderByStep.orderBy(Field<?>... fields) Add an ORDER BY clause to the function.
AggregateFilterStep<T>	ArrayAggOrderByStep.orderBy(SortField<?>... fields) Add an ORDER BY clause to the function.
AggregateFilterStep<T>	OrderedAggregateFunction.withinGroupOrderBy(java.util.Collection<? extends SortField<?>> fields) Add an WITHIN GROUP (ORDER BY ..)
AggregateFilterStep<T>	OrderedAggregateFunction.withinGroupOrderBy(Field<?>... fields) Add an WITHIN GROUP (ORDER BY ..)
AggregateFilterStep<T>	OrderedAggregateFunction.withinGroupOrderBy(SortField<?>... fields) Add an WITHIN GROUP (ORDER BY ..)