org.jooq

Interface AggregateFunction<T>

All Superinterfaces:

AggregateFilterStep<T>, Field<T>, FieldOrRow, GroupField, QueryPart, SelectField<T>, Serializable, WindowBeforeOverStep<T>, WindowOverStep<T>

All Known Subinterfaces:

GroupConcatOrderByStep, GroupConcatSeparatorStep

public interface AggregateFunction<T>
extends AggregateFilterStep<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

Modifier and Type	Method and Description
AggregateFilterStep<T>	keepDenseRankFirstOrderBy(Collection<? extends 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.
AggregateFilterStep<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.
AggregateFilterStep<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.
AggregateFilterStep<T>	keepDenseRankLastOrderBy(Collection<? extends 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.
AggregateFilterStep<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.
AggregateFilterStep<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.

Methods inherited from interface org.jooq.AggregateFilterStep

filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere

Methods inherited from interface org.jooq.WindowOverStep

over, over, over, over, over

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, ceil, charLength, coalesce, coalesce, coerce, coerce, coerce, compare, compare, compare, compare, concat, concat, contains, contains, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, firstValue, floor, ge, ge, ge, ge, getBinding, getComment, getConverter, getDataType, getDataType, getName, getType, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isNotDistinctFrom, isNotDistinctFrom, isNotNull, isNull, isTrue, lag, lag, lag, lag, lastValue, le, le, le, le, lead, lead, lead, lead, least, least, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, plus, plus, plus, position, position, pow, power, rad, repeat, repeat, replace, replace, replace, replace, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, sin, sinh, sort, sort, sortAsc, sortAsc, sortDesc, sortDesc, sqrt, startsWith, startsWith, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, trim, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Method Detail

keepDenseRankFirstOrderBy

@Support(value=ORACLE)
AggregateFilterStep<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

@Support(value=ORACLE)
AggregateFilterStep<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

@Support(value=ORACLE)
AggregateFilterStep<T> keepDenseRankFirstOrderBy(Collection<? extends 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

@Support(value=ORACLE)
AggregateFilterStep<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

@Support(value=ORACLE)
AggregateFilterStep<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

@Support(value=ORACLE)
AggregateFilterStep<T> keepDenseRankLastOrderBy(Collection<? extends 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.