Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
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. |
Modifier and Type | Method and Description |
---|---|
AggregateFilterStep<T> |
AggregateFunction.keepDenseRankFirstOrderBy(Collection<? extends OrderField<?>> 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(OrderField<?>... 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(Collection<? extends OrderField<?>> 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(OrderField<?>... 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(Collection<? extends OrderField<?>> fields)
Add an
ORDER BY clause to the function. |
AggregateFilterStep<T> |
ArrayAggOrderByStep.orderBy(OrderField<?>... fields)
Add an
ORDER BY clause to the function. |
AggregateFilterStep<T> |
OrderedAggregateFunction.withinGroupOrderBy(Collection<? extends OrderField<?>> fields)
Add an
WITHIN GROUP (ORDER BY ..) |
AggregateFilterStep<T> |
OrderedAggregateFunction.withinGroupOrderBy(OrderField<?>... fields)
Add an
WITHIN GROUP (ORDER BY ..) |
<T> AggregateFilterStep<T> |
OrderedAggregateFunctionOfDeferredType.withinGroupOrderBy(OrderField<T> field)
Add an
WITHIN GROUP (ORDER BY ..) |
Copyright © 2019. All rights reserved.