static <T> @NotNull AggregateFunction<T> |
DSL.aggregate(String name,
Class<T> type,
Field<?>... arguments) |
aggregate() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
static <T> @NotNull AggregateFunction<T> |
DSL.aggregate(String name,
DataType<T> type,
Field<?>... arguments) |
aggregate() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
static <T> @NotNull AggregateFunction<T> |
DSL.aggregate(Name name,
Class<T> type,
Field<?>... arguments) |
aggregate() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
static <T> @NotNull AggregateFunction<T> |
DSL.aggregate(Name name,
DataType<T> type,
Field<?>... arguments) |
aggregate() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
static <T> @NotNull AggregateFunction<T> |
DSL.aggregateDistinct(String name,
Class<T> type,
Field<?>... arguments) |
aggregateDistinct() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
static <T> @NotNull AggregateFunction<T> |
DSL.aggregateDistinct(String name,
DataType<T> type,
Field<?>... arguments) |
aggregateDistinct() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
static <T> @NotNull AggregateFunction<T> |
DSL.aggregateDistinct(Name name,
Class<T> type,
Field<?>... arguments) |
aggregateDistinct() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
static <T> @NotNull AggregateFunction<T> |
DSL.aggregateDistinct(Name name,
DataType<T> type,
Field<?>... arguments) |
aggregateDistinct() can be used to access native or
user-defined aggregate functions that are not yet or insufficiently
supported by jOOQ.
|
AggregateFunction<T> |
AbstractRoutine.asAggregateFunction() |
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.avg(Field<? extends Number> field) |
Get the average over a numeric field: avg(field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.avgDistinct(Field<? extends Number> field) |
Get the average over a numeric field: avg(distinct field).
|
static @NotNull AggregateFunction<Boolean> |
DSL.boolAnd(Condition condition) |
Get the every value over a condition: bool_and(condition).
|
static @NotNull AggregateFunction<Boolean> |
DSL.boolAnd(Field<Boolean> field) |
Get the every value over a field: bool_and(field).
|
static @NotNull AggregateFunction<Boolean> |
DSL.boolOr(Condition condition) |
Get the every value over a condition: bool_and(condition).
|
static @NotNull AggregateFunction<Boolean> |
DSL.boolOr(Field<Boolean> field) |
Get the every value over a field: bool_and(field).
|
static @NotNull AggregateFunction<Integer> |
DSL.count() |
Get the count(*) function.
|
static @NotNull AggregateFunction<Integer> |
DSL.count(Field<?> field) |
Get the count(field) function.
|
static @NotNull AggregateFunction<Integer> |
DSL.count(SelectFieldOrAsterisk field) |
Get the count(field) function.
|
static @NotNull AggregateFunction<Integer> |
DSL.count(Table<?> table) |
Get the count(table) function.
|
static @NotNull AggregateFunction<Integer> |
DSL.countDistinct(Field<?> field) |
Get the count(distinct field) function.
|
static @NotNull AggregateFunction<Integer> |
DSL.countDistinct(Field<?>... fields) |
Get the count(distinct field1, field2) function.
|
static @NotNull AggregateFunction<Integer> |
DSL.countDistinct(SelectFieldOrAsterisk field) |
Get the count(distinct field) function.
|
static @NotNull AggregateFunction<Integer> |
DSL.countDistinct(Table<?> table) |
Get the count(distinct table) function.
|
static @NotNull AggregateFunction<Boolean> |
DSL.every(Condition condition) |
Get the every value over a condition: every(condition).
|
static @NotNull AggregateFunction<Boolean> |
DSL.every(Field<Boolean> field) |
Get the every value over a field: every(field).
|
static @NotNull AggregateFunction<String> |
DSL.groupConcat(Field<?> field,
String separator) |
Deprecated.
|
static <T> @NotNull AggregateFunction<T> |
DSL.max(Field<T> field) |
Get the max value over a field: max(field).
|
static <T> @NotNull AggregateFunction<T> |
DSL.maxDistinct(Field<T> field) |
Get the max value over a field: max(distinct field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.median(Field<? extends Number> field) |
Get the median over a numeric field: median(field).
|
static <T> @NotNull AggregateFunction<T> |
DSL.min(Field<T> field) |
Get the min value over a field: min(field).
|
static <T> @NotNull AggregateFunction<T> |
DSL.minDistinct(Field<T> field) |
Get the min value over a field: min(distinct field).
|
static <T> @NotNull AggregateFunction<T> |
DSL.mode(Field<T> field) |
The mode(field) aggregate function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.product(Field<? extends Number> field) |
Get the product over a numeric field: product(field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.productDistinct(Field<? extends Number> field) |
Get the sum over a numeric field: product(distinct field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrAvgX(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_AVGX linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrAvgY(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_AVGY linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrCount(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_COUNT linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrIntercept(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_INTERCEPT linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrR2(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_R2 linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrSlope(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_SLOPE linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrSXX(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_SXX linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrSXY(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_SXY linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.regrSYY(Field<? extends Number> y,
Field<? extends Number> x) |
Get the REGR_SYY linear regression function.
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.stddevPop(Field<? extends Number> field) |
Get the population standard deviation of a numeric field: stddev_pop(field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.stddevSamp(Field<? extends Number> field) |
Get the sample standard deviation of a numeric field: stddev_samp(field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.sum(Field<? extends Number> field) |
Get the sum over a numeric field: sum(field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.sumDistinct(Field<? extends Number> field) |
Get the sum over a numeric field: sum(distinct field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.varPop(Field<? extends Number> field) |
Get the population variance of a numeric field: var_pop(field).
|
static @NotNull AggregateFunction<BigDecimal> |
DSL.varSamp(Field<? extends Number> field) |
Get the sample variance of a numeric field: var_samp(field).
|