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
 WindowPartitionByStep<T> over()
          Turn this aggregate function into a window function, for example MAX(ID) OVER (PARTITION BY 1) Window functions are supported in DB2, Postgres, Oracle, SQL Server and Sybase.
 
Methods inherited from interface org.jooq.Field
abs, acos, add, add, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, 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, equal, equal, equal, equalAll, equalAll, equalAll, equalAny, equalAny, equalAny, equalIgnoreCase, equalIgnoreCase, equals, equalSome, exp, extract, firstValue, floor, getName, getType, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqualAll, greaterOrEqualAll, greaterOrEqualAll, greaterOrEqualAny, greaterOrEqualAny, greaterOrEqualAny, greaterOrEqualSome, greaterThan, greaterThan, greaterThan, greaterThanAll, greaterThanAll, greaterThanAll, greaterThanAny, greaterThanAny, greaterThanAny, greaterThanSome, greatest, greatest, in, in, in, in, isFalse, isNotNull, isNull, isNullLiteral, isTrue, lag, lag, lag, lag, lastValue, 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, ln, log, lower, lpad, lpad, lpad, lpad, ltrim, max, maxOver, median, min, minOver, mod, mod, mul, mul, neg, notBetween, notBetween, notEqual, notEqual, notEqual, notEqualAll, notEqualAll, notEqualAll, notEqualAny, notEqualAny, notEqualAny, notEqualIgnoreCase, notEqualIgnoreCase, notEqualSome, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, 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.Attachable
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, for 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>


Copyright © 2012. All Rights Reserved.