org.jooq
Interface AggregateFunction<T>

All Superinterfaces:

Adapter, AliasProvider<Field<T>>, Attachable, Comparable<NamedQueryPart>, Field<T>, NamedQueryPart, NamedTypeProviderQueryPart<T>, QueryPart, Serializable, WindowOverStep<T>

All Known Subinterfaces:

GroupConcatOrderByStep, GroupConcatSeparatorStep

public interface AggregateFunction<T>
extends Field<T>, WindowOverStep<T>

An aggregate function is a special field that is usually used in a GROUP BY context. It is also the base for window function construction.

Author:

Lukas Eder

Method Summary

WindowBeforeOverStep<T>	keepDenseRankFirstOrderBy(Collection<SortField<?>> fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowBeforeOverStep<T>	keepDenseRankFirstOrderBy(Field<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowBeforeOverStep<T>	keepDenseRankFirstOrderBy(SortField<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowBeforeOverStep<T>	keepDenseRankLastOrderBy(Collection<SortField<?>> fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowBeforeOverStep<T>	keepDenseRankLastOrderBy(Field<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowBeforeOverStep<T>	keepDenseRankLastOrderBy(SortField<?>... fields) Restrict this aggregate function to FIRST values An example: MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1) This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.
WindowPartitionByStep<T>	over() Turn this aggregate function into a window function.

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, betweenSymmetric, betweenSymmetric, bitLength, cast, cast, cast, ceil, charLength, coalesce, coalesce, concat, concat, contains, contains, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, endsWith, endsWith, eq, eq, eq, equal, equal, equal, equalAll, equalAll, equalAll, equalAny, equalAny, equalAny, equalIgnoreCase, equalIgnoreCase, equals, equalSome, exp, extract, firstValue, floor, ge, ge, ge, getName, getType, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqualAll, greaterOrEqualAll, greaterOrEqualAll, greaterOrEqualAny, greaterOrEqualAny, greaterOrEqualAny, greaterOrEqualSome, greaterThan, greaterThan, greaterThan, greaterThanAll, greaterThanAll, greaterThanAll, greaterThanAny, greaterThanAny, greaterThanAny, greaterThanSome, greatest, greatest, gt, gt, gt, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isNotDistinctFrom, isNotDistinctFrom, isNotNull, isNull, isNullLiteral, isTrue, lag, lag, lag, lag, lastValue, le, le, le, lead, lead, lead, lead, least, least, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqualAll, lessOrEqualAll, lessOrEqualAll, lessOrEqualAny, lessOrEqualAny, lessOrEqualAny, lessOrEqualSome, lessThan, lessThan, lessThan, lessThanAll, lessThanAll, lessThanAll, lessThanAny, lessThanAny, lessThanAny, lessThanSome, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, mod, mod, mul, mul, ne, ne, ne, neg, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notEqual, notEqual, notEqual, notEqualAll, notEqualAll, notEqualAll, notEqualAny, notEqualAny, notEqualAny, notEqualIgnoreCase, notEqualIgnoreCase, notEqualSome, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, position, position, power, rad, repeat, repeat, replace, replace, replace, replace, round, round, rpad, rpad, rpad, rpad, rtrim, sign, sin, sinh, sort, sortAsc, sortAsc, sortDesc, sortDesc, sqrt, startsWith, startsWith, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, sum, sumOver, tan, tanh, trim, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.NamedTypeProviderQueryPart

getDataType, getDataType

Methods inherited from interface org.jooq.QueryPart

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Methods inherited from interface java.lang.Comparable

compareTo

Method Detail

over

WindowPartitionByStep<T> over()

Turn this aggregate function into a window function.

An example:

 MAX(ID) OVER (PARTITION BY 1)
 

Window functions are supported in DB2, Postgres, Oracle, SQL Server and Sybase.

Specified by:

over in interface WindowOverStep<T>

keepDenseRankFirstOrderBy

WindowBeforeOverStep<T> keepDenseRankFirstOrderBy(Field<?>... fields)

Restrict this aggregate function to FIRST values

An example:

 MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1)
 

This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

keepDenseRankFirstOrderBy

WindowBeforeOverStep<T> keepDenseRankFirstOrderBy(SortField<?>... fields)

Restrict this aggregate function to FIRST values

An example:

 MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1)
 

This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

keepDenseRankFirstOrderBy

WindowBeforeOverStep<T> keepDenseRankFirstOrderBy(Collection<SortField<?>> fields)

Restrict this aggregate function to FIRST values

An example:

 MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1)
 

This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

keepDenseRankLastOrderBy

WindowBeforeOverStep<T> keepDenseRankLastOrderBy(Field<?>... fields)

Restrict this aggregate function to FIRST values

An example:

 MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1)
 

This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

keepDenseRankLastOrderBy

WindowBeforeOverStep<T> keepDenseRankLastOrderBy(SortField<?>... fields)

Restrict this aggregate function to FIRST values

An example:

 MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1)
 

This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.

keepDenseRankLastOrderBy

WindowBeforeOverStep<T> keepDenseRankLastOrderBy(Collection<SortField<?>> fields)

Restrict this aggregate function to FIRST values

An example:

 MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1)
 

This clause is only available on MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions.