Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
Modifier and Type | Method and Description |
---|---|
WindowBeforeOverStep<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. |
WindowBeforeOverStep<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. |
WindowBeforeOverStep<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. |
WindowBeforeOverStep<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. |
WindowBeforeOverStep<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. |
WindowBeforeOverStep<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. |
Copyright © 2014. All Rights Reserved.