org.jooq
Interface WindowPartitionByStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

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

public interface WindowPartitionByStep<T>
extends WindowOrderByStep<T>

This type is used for the window function DSL API.

Example:

 field.firstValue()
      .ignoreNulls()
      .over()
      .partitionBy(AUTHOR_ID)
      .orderBy(PUBLISHED_IN.asc())
      .rowsBetweenUnboundedPreceding()
      .andUnboundedFollowing()
 

Author:

Lukas Eder

Method Summary

WindowOrderByStep<T>	partitionBy(Field<?>... fields) Add a PARTITION BY clause to the window functions.
WindowOrderByStep<T>	partitionByOne() Add a PARTITION BY 1 clause to the window functions, where such a clause is required by the syntax of an RDBMS.

Methods inherited from interface org.jooq.WindowOrderByStep

orderBy, orderBy, orderBy

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

partitionBy

WindowOrderByStep<T> partitionBy(Field<?>... fields)

Add a PARTITION BY clause to the window functions.

partitionByOne

WindowOrderByStep<T> partitionByOne()

Add a PARTITION BY 1 clause to the window functions, where such a clause is required by the syntax of an RDBMS.

This clause is not supported in the Sybase dialect. If you use it, jOOQ will simply ignore it.