Uses of Interface
org.jooq.AggregateFunction
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of AggregateFunction in org.jooq
Modifier and TypeInterfaceDescriptioninterface
MySQL'sGROUP_CONCAT
function.interface
MySQL'sGROUP_CONCAT
function.Modifier and TypeMethodDescription@NotNull AggregateFunction<String>
Specify the separator on theGROUP_CONCAT
function. -
Uses of AggregateFunction in org.jooq.impl
Modifier and TypeInterfaceDescriptionstatic interface
QOM.AnyValue<T>
TheANY VALUE
function.static interface
QOM.ArrayAgg<T>
static interface
TheAVG
function.static interface
QOM.BitAndAgg<T extends Number>
TheBIT AND AGG
function.static interface
QOM.BitOrAgg<T extends Number>
TheBIT OR AGG
function.static interface
QOM.BitXorAgg<T extends Number>
TheBIT XOR AGG
function.static interface
TheBOOL AND
function.static interface
TheBOOL OR
function.static interface
QOM.Collect<T,
A extends ArrayRecord<T>> static interface
TheCORR
function.static interface
TheCOUNT
function.static interface
static interface
TheCOVAR POP
function.static interface
TheCOVAR SAMP
function.static interface
static interface
static interface
QOM.Max<T>
TheMAX
function.static interface
TheMEDIAN
function.static interface
QOM.Min<T>
TheMIN
function.static interface
QOM.Mode<T>
static interface
QOM.MultisetAgg<R extends Record>
static interface
ThePRODUCT
function.static interface
static interface
TheREGR AVGX
function.static interface
TheREGR AVGY
function.static interface
TheREGR COUNT
function.static interface
TheREGR INTERCEPT
function.static interface
TheREGR R2
function.static interface
TheREGR SLOPE
function.static interface
TheREGR SXX
function.static interface
TheREGR SXY
function.static interface
TheREGR SYY
function.static interface
TheSTDDEV POP
function.static interface
TheSTDDEV SAMP
function.static interface
TheSUM
function.static interface
TheVAR POP
function.static interface
TheVAR SAMP
function.static interface
Modifier and TypeMethodDescriptionstatic <T> @NotNull AggregateFunction<T>
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>
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>
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>
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>
TheANY_VALUE
function.final AggregateFunction<T>
AbstractRoutine.asAggregateFunction()
static @NotNull AggregateFunction<BigDecimal>
TheAVG
function.static @NotNull AggregateFunction<BigDecimal>
DSL.avgDistinct
(Field<? extends Number> field) TheAVG_DISTINCT
function.static <T extends Number>
@NotNull AggregateFunction<T>TheBIT_AND_AGG
function.static <T extends Number>
@NotNull AggregateFunction<T>TheBIT_OR_AGG
function.static <T extends Number>
@NotNull AggregateFunction<T>TheBIT_XOR_AGG
function.static @NotNull AggregateFunction<Boolean>
TheBOOL_AND
function.static @NotNull AggregateFunction<Boolean>
TheBOOL_AND
function.static @NotNull AggregateFunction<Boolean>
TheBOOL_OR
function.static @NotNull AggregateFunction<Boolean>
TheBOOL_OR
function.static @NotNull AggregateFunction<BigDecimal>
TheCORR
function.static @NotNull AggregateFunction<Integer>
DSL.count()
Get the count(*) function.static @NotNull AggregateFunction<Integer>
TheCOUNT
function.static @NotNull AggregateFunction<Integer>
DSL.count
(SelectFieldOrAsterisk field) Get the count(field) function.static @NotNull AggregateFunction<Integer>
Get the count(table) function.static @NotNull AggregateFunction<Integer>
DSL.countDistinct
(Field<?> field) TheCOUNT_DISTINCT
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>
TheCOVAR_POP
function.static @NotNull AggregateFunction<BigDecimal>
TheCOVAR_SAMP
function.static @NotNull AggregateFunction<Boolean>
TheEVERY
function, an alias for theBOOL_AND
function.static @NotNull AggregateFunction<Boolean>
TheEVERY
function, an alias for theBOOL_AND
function.static @NotNull AggregateFunction<String>
DSL.groupConcat
(Field<?> field, String separator) Deprecated, for removal: This API element is subject to removal in a future version.static <T> @NotNull AggregateFunction<T>
TheMAX
function.static <T> @NotNull AggregateFunction<T>
DSL.maxDistinct
(Field<T> field) TheMAX_DISTINCT
function.static @NotNull AggregateFunction<BigDecimal>
TheMEDIAN
function.static <T> @NotNull AggregateFunction<T>
TheMIN
function.static <T> @NotNull AggregateFunction<T>
DSL.minDistinct
(Field<T> field) TheMIN_DISTINCT
function.static <T> @NotNull AggregateFunction<T>
Themode(field)
aggregate function.static @NotNull AggregateFunction<BigDecimal>
ThePRODUCT
function.static @NotNull AggregateFunction<BigDecimal>
DSL.productDistinct
(Field<? extends Number> field) ThePRODUCT_DISTINCT
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_AVGX
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_AVGY
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_COUNT
function.static @NotNull AggregateFunction<BigDecimal>
DSL.regrIntercept
(Field<? extends Number> y, Field<? extends Number> x) TheREGR_INTERCEPT
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_R2
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_SLOPE
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_SXX
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_SXY
function.static @NotNull AggregateFunction<BigDecimal>
TheREGR_SYY
function.static @NotNull AggregateFunction<BigDecimal>
TheSTDDEV_POP
function.static @NotNull AggregateFunction<BigDecimal>
DSL.stddevSamp
(Field<? extends Number> field) TheSTDDEV_SAMP
function.static @NotNull AggregateFunction<BigDecimal>
TheSUM
function.static @NotNull AggregateFunction<BigDecimal>
DSL.sumDistinct
(Field<? extends Number> field) TheSUM_DISTINCT
function.static @NotNull AggregateFunction<BigDecimal>
TheVAR_POP
function.static @NotNull AggregateFunction<BigDecimal>
TheVAR_SAMP
function.
DSL.groupConcat(Field)
andGroupConcatSeparatorStep.separator(String)
instead.