org.jooq

Interface WindowBeforeOverStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

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

All Known Subinterfaces:

AggregateFilterStep<T>, AggregateFunction<T>, ArrayAggOrderByStep<T>, GroupConcatOrderByStep, GroupConcatSeparatorStep

public interface WindowBeforeOverStep<T>
extends WindowOverStep<T>, Field<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()
 

Unlike in WindowOverStep, OVER() is an optional clause clause.

Author:

Lukas Eder

Method Summary

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, 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, 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, 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, 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, power, rad, 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, 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