static OrderedAggregateFunction<BigDecimal> |
DSL.cumeDist(Collection<? extends Field<?>> fields) |
The cume_dist(expr) within group (order by [order clause])
ordered-set aggregate function.
|
static OrderedAggregateFunction<BigDecimal> |
DSL.cumeDist(Field<?>... fields) |
The cume_dist(expr) within group (order by [order clause])
ordered-set aggregate function.
|
static OrderedAggregateFunction<Integer> |
DSL.denseRank(Collection<? extends Field<?>> fields) |
The dense_rank(expr) within group (order by [order clause])
ordered-set aggregate function.
|
static OrderedAggregateFunction<Integer> |
DSL.denseRank(Field<?>... fields) |
The dense_rank(expr) within group (order by [order clause])
ordered-set aggregate function.
|
static OrderedAggregateFunction<String> |
DSL.listAgg(Field<?> field) |
Get the aggregated concatenation for a field.
|
static OrderedAggregateFunction<String> |
DSL.listAgg(Field<?> field,
String separator) |
Get the aggregated concatenation for a field.
|
static OrderedAggregateFunction<BigDecimal> |
DSL.percentileCont(Number number) |
The
percentile_cont([number]) within group (order by [column])
function.
|
static OrderedAggregateFunction<BigDecimal> |
DSL.percentileCont(Field<? extends Number> field) |
The
percentile_cont([number]) within group (order by [column])
function.
|
static OrderedAggregateFunction<BigDecimal> |
DSL.percentileDisc(Number number) |
The
percentile_disc([number]) within group (order by [column])
function.
|
static OrderedAggregateFunction<BigDecimal> |
DSL.percentileDisc(Field<? extends Number> field) |
The
percentile_disc([number]) within group (order by [column])
function.
|
static OrderedAggregateFunction<Integer> |
DSL.percentRank(Collection<? extends Field<?>> fields) |
The percent_rank(expr) within group (order by [order clause])
ordered-set aggregate function.
|
static OrderedAggregateFunction<Integer> |
DSL.percentRank(Field<?>... fields) |
The percent_rank(expr) within group (order by [order clause])
ordered-set aggregate function.
|
static OrderedAggregateFunction<Integer> |
DSL.rank(Collection<? extends Field<?>> fields) |
The rank(expr) within group (order by [order clause])
ordered-set aggregate function.
|
static OrderedAggregateFunction<Integer> |
DSL.rank(Field<?>... fields) |
The rank(expr) within group (order by [order clause])
ordered-set aggregate function.
|