public interface AggregateFunction<T> extends AggregateFilterStep<T>
GROUP BY context. It is also the base for window function
construction.| Modifier and Type | Method and Description |
|---|---|
AggregateFilterStep<T> |
keepDenseRankFirstOrderBy(Collection<? extends OrderField<?>> 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(OrderField<?>... 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 OrderField<?>> 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(OrderField<?>... 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. |
filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhereabs, acos, add, add, as, as, 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, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, collate, collate, collate, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, 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, field, firstValue, floor, from, ge, ge, ge, ge, get, getBinding, getComment, getConverter, getDataType, getDataType, getName, getType, getValue, 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, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, 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, original, plus, plus, plus, position, position, pow, pow, power, power, rad, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOvergetQualifiedName, getUnqualifiedName@Support(value=ORACLE) AggregateFilterStep<T> keepDenseRankFirstOrderBy(OrderField<?>... fields)
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.
@Support(value=ORACLE) AggregateFilterStep<T> keepDenseRankFirstOrderBy(Collection<? extends OrderField<?>> fields)
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.
@Support(value=ORACLE) AggregateFilterStep<T> keepDenseRankLastOrderBy(OrderField<?>... fields)
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.
@Support(value=ORACLE) AggregateFilterStep<T> keepDenseRankLastOrderBy(Collection<? extends OrderField<?>> fields)
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.
Copyright © 2019. All rights reserved.