Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
Modifier and Type | Interface and Description |
---|---|
interface |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
Modifier and Type | Method and Description |
---|---|
AggregateFunction<String> |
GroupConcatSeparatorStep.separator(String separator)
Specify the separator on the
GROUP_CONCAT function. |
Modifier and Type | Method and Description |
---|---|
AggregateFunction<T> |
AbstractRoutine.asAggregateFunction() |
static AggregateFunction<BigDecimal> |
DSL.avg(Field<? extends Number> field)
Get the average over a numeric field: avg(field).
|
static AggregateFunction<BigDecimal> |
DSL.avgDistinct(Field<? extends Number> field)
Get the average over a numeric field: avg(distinct field).
|
static AggregateFunction<Boolean> |
DSL.boolAnd(Condition condition)
Get the every value over a condition: bool_and(condition).
|
static AggregateFunction<Boolean> |
DSL.boolAnd(Field<Boolean> field)
Get the every value over a field: bool_and(field).
|
static AggregateFunction<Boolean> |
DSL.boolOr(Condition condition)
Get the every value over a condition: bool_and(condition).
|
static AggregateFunction<Boolean> |
DSL.boolOr(Field<Boolean> field)
Get the every value over a field: bool_and(field).
|
static AggregateFunction<Integer> |
DSL.count()
Get the count(*) function.
|
static AggregateFunction<Integer> |
DSL.count(Field<?> field)
Get the count(field) function.
|
static AggregateFunction<Integer> |
DSL.count(SelectFieldOrAsterisk field)
Get the count(field) function.
|
static AggregateFunction<Integer> |
DSL.count(Table<?> table)
Get the count(table) function.
|
static AggregateFunction<Integer> |
DSL.countDistinct(Field<?>... fields)
Get the count(distinct field1, field2) function.
|
static AggregateFunction<Integer> |
DSL.countDistinct(Field<?> field)
Get the count(distinct field) function.
|
static AggregateFunction<Integer> |
DSL.countDistinct(SelectFieldOrAsterisk field)
Get the count(distinct field) function.
|
static AggregateFunction<Integer> |
DSL.countDistinct(Table<?> table)
Get the count(distinct table) function.
|
static AggregateFunction<Boolean> |
DSL.every(Condition condition)
Get the every value over a condition: every(condition).
|
static AggregateFunction<Boolean> |
DSL.every(Field<Boolean> field)
Get the every value over a field: every(field).
|
static AggregateFunction<String> |
DSL.groupConcat(Field<?> field,
String separator)
Get the aggregated concatenation for a field.
|
static <T> AggregateFunction<T> |
DSL.max(Field<T> field)
Get the max value over a field: max(field).
|
static <T> AggregateFunction<T> |
DSL.maxDistinct(Field<T> field)
Get the max value over a field: max(distinct field).
|
static AggregateFunction<BigDecimal> |
DSL.median(Field<? extends Number> field)
Get the median over a numeric field: median(field).
|
static <T> AggregateFunction<T> |
DSL.min(Field<T> field)
Get the min value over a field: min(field).
|
static <T> AggregateFunction<T> |
DSL.minDistinct(Field<T> field)
Get the min value over a field: min(distinct field).
|
static AggregateFunction<BigDecimal> |
DSL.regrAvgX(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_AVGX linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrAvgY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_AVGY linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrCount(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_COUNT linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrIntercept(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_INTERCEPT linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrR2(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_R2 linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSlope(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SLOPE linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSXX(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SXX linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSXY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SXY linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.regrSYY(Field<? extends Number> y,
Field<? extends Number> x)
Get the
REGR_SYY linear regression function. |
static AggregateFunction<BigDecimal> |
DSL.stddevPop(Field<? extends Number> field)
Get the population standard deviation of a numeric field: stddev_pop(field).
|
static AggregateFunction<BigDecimal> |
DSL.stddevSamp(Field<? extends Number> field)
Get the sample standard deviation of a numeric field: stddev_samp(field).
|
static AggregateFunction<BigDecimal> |
DSL.sum(Field<? extends Number> field)
Get the sum over a numeric field: sum(field).
|
static AggregateFunction<BigDecimal> |
DSL.sumDistinct(Field<? extends Number> field)
Get the sum over a numeric field: sum(distinct field).
|
static AggregateFunction<BigDecimal> |
DSL.varPop(Field<? extends Number> field)
Get the population variance of a numeric field: var_pop(field).
|
static AggregateFunction<BigDecimal> |
DSL.varSamp(Field<? extends Number> field)
Get the sample variance of a numeric field: var_samp(field).
|
Copyright © 2019. All rights reserved.