Uses of Interface org.jooq.AggregateFunction (jOOQ 3.15.12 API)

Packages that use AggregateFunction

Package

Description

org.jooq

This package contains jOOQ's public API.

org.jooq.impl

This package contains jOOQ's implementation classes.

Uses of AggregateFunction in org.jooq

Subinterfaces of AggregateFunction in org.jooq

Modifier and Type

Interface

Description

interface

GroupConcatOrderByStep

MySQL's GROUP_CONCAT function.

interface

GroupConcatSeparatorStep

MySQL's GROUP_CONCAT function.

Methods in org.jooq that return AggregateFunction

Modifier and Type

Method

Description

@NotNull AggregateFunction<String>

GroupConcatSeparatorStep.separator(String separator)

Specify the separator on the GROUP_CONCAT function.
Uses of AggregateFunction in org.jooq.impl

Methods in org.jooq.impl that return AggregateFunction

Modifier and Type

Method

Description

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.

static <T> @NotNull AggregateFunction<T>

DSL.anyValue(Field<T> value)

The ANY_VALUE function.

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 <T extends Number> @NotNull AggregateFunction<T>

DSL.bitAndAgg(Field<T> value)

The BIT_AND_AGG function.

static <T extends Number> @NotNull AggregateFunction<T>

DSL.bitOrAgg(Field<T> value)

The BIT_OR_AGG function.

static <T extends Number> @NotNull AggregateFunction<T>

DSL.bitXorAgg(Field<T> value)

The BIT_XOR_AGG function.

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<BigDecimal>

DSL.corr(Field<? extends Number> y, Field<? extends Number> x)

The CORR function.

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<BigDecimal>

DSL.covarPop(Field<? extends Number> y, Field<? extends Number> x)

The COVAR_POP function.

static @NotNull AggregateFunction<BigDecimal>

DSL.covarSamp(Field<? extends Number> y, Field<? extends Number> x)

The COVAR_SAMP 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, for removal: This API element is subject to removal in a future version.
- [#7956] - 3.12.0 - Use DSL.groupConcat(Field) and GroupConcatSeparatorStep.separator(String) instead.

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)

The MEDIAN function.

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)

The REGR_AVG_X function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrAvgY(Field<? extends Number> y, Field<? extends Number> x)

The REGR_AVG_Y function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrCount(Field<? extends Number> y, Field<? extends Number> x)

The REGR_COUNT function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrIntercept(Field<? extends Number> y, Field<? extends Number> x)

The REGR_INTERCEPT function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrR2(Field<? extends Number> y, Field<? extends Number> x)

The REGR_R2 function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrSlope(Field<? extends Number> y, Field<? extends Number> x)

The REGR_SLOPE function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrSXX(Field<? extends Number> y, Field<? extends Number> x)

The REGR_SXX function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrSXY(Field<? extends Number> y, Field<? extends Number> x)

The REGR_SXY function.

static @NotNull AggregateFunction<BigDecimal>

DSL.regrSYY(Field<? extends Number> y, Field<? extends Number> x)

The REGR_SYY function.

static @NotNull AggregateFunction<BigDecimal>

DSL.stddevPop(Field<? extends Number> field)

The STDDEV_POP function.

static @NotNull AggregateFunction<BigDecimal>

DSL.stddevSamp(Field<? extends Number> field)

The STDDEV_SAMP function.

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)

The VAR_POP function.

static @NotNull AggregateFunction<BigDecimal>

DSL.varSamp(Field<? extends Number> field)

The VAR_SAMP function.

Uses of Interfaceorg.jooq.AggregateFunction

Uses of AggregateFunction in org.jooq

Uses of AggregateFunction in org.jooq.impl

Uses of Interface
org.jooq.AggregateFunction