org.jooq
Interface WindowRowsStep<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>

public interface WindowRowsStep<T>
extends WindowFinalStep<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()
 

Note, that the functionality provided by this interface is not supported in SQLDialect.SQLSERVER

Author:

Lukas Eder

Method Summary

WindowRowsAndStep<T>	rowsBetweenCurrentRow() Add a ROWS BETWEEN CURRENT ROW ...
WindowRowsAndStep<T>	rowsBetweenFollowing(int number) Add a ROWS BETWEEN [number] FOLLOWING ...
WindowRowsAndStep<T>	rowsBetweenPreceding(int number) Add a ROWS BETWEEN [number] PRECEDING ...
WindowRowsAndStep<T>	rowsBetweenUnboundedFollowing() Add a ROWS BETWEEN UNBOUNDED FOLLOWING ...
WindowRowsAndStep<T>	rowsBetweenUnboundedPreceding() Add a ROWS BETWEEN UNBOUNDED PRECEDING ...
WindowFinalStep<T>	rowsCurrentRow() Add a ROWS CURRENT ROW frame clause to the window function.
WindowFinalStep<T>	rowsFollowing(int number) Add a ROWS [number] FOLLOWING frame clause to the window function.
WindowFinalStep<T>	rowsPreceding(int number) Add a ROWS [number] PRECEDING frame clause to the window function.
WindowFinalStep<T>	rowsUnboundedFollowing() Add a ROWS UNBOUNDED FOLLOWING frame clause to the window function.
WindowFinalStep<T>	rowsUnboundedPreceding() Add a ROWS UNBOUNDED PRECEDING frame clause to the window function.

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, betweenSymmetric, betweenSymmetric, 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, eq, eq, eq, equal, equal, equal, equalAll, equalAll, equalAll, equalAny, equalAny, equalAny, equalIgnoreCase, equalIgnoreCase, equals, equalSome, exp, extract, firstValue, floor, ge, ge, ge, getName, getType, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqualAll, greaterOrEqualAll, greaterOrEqualAll, greaterOrEqualAny, greaterOrEqualAny, greaterOrEqualAny, greaterOrEqualSome, greaterThan, greaterThan, greaterThan, greaterThanAll, greaterThanAll, greaterThanAll, greaterThanAny, greaterThanAny, greaterThanAny, greaterThanSome, greatest, greatest, gt, gt, gt, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isNotDistinctFrom, isNotDistinctFrom, isNotNull, isNull, isNullLiteral, isTrue, lag, lag, lag, lag, lastValue, le, le, le, 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, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, mod, mod, mul, mul, ne, ne, ne, neg, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notEqual, notEqual, notEqual, notEqualAll, notEqualAll, notEqualAll, notEqualAny, notEqualAny, notEqualAny, notEqualIgnoreCase, notEqualIgnoreCase, notEqualSome, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, 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.QueryPart

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Methods inherited from interface java.lang.Comparable

compareTo

Method Detail

rowsUnboundedPreceding

WindowFinalStep<T> rowsUnboundedPreceding()

Add a ROWS UNBOUNDED PRECEDING frame clause to the window function.

rowsPreceding

WindowFinalStep<T> rowsPreceding(int number)

Add a ROWS [number] PRECEDING frame clause to the window function.

rowsCurrentRow

WindowFinalStep<T> rowsCurrentRow()

Add a ROWS CURRENT ROW frame clause to the window function.

rowsUnboundedFollowing

WindowFinalStep<T> rowsUnboundedFollowing()

Add a ROWS UNBOUNDED FOLLOWING frame clause to the window function.

rowsFollowing

WindowFinalStep<T> rowsFollowing(int number)

Add a ROWS [number] FOLLOWING frame clause to the window function.

rowsBetweenUnboundedPreceding

WindowRowsAndStep<T> rowsBetweenUnboundedPreceding()

Add a ROWS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window function.

rowsBetweenPreceding

WindowRowsAndStep<T> rowsBetweenPreceding(int number)

Add a ROWS BETWEEN [number] PRECEDING ... frame clause to the window function.

rowsBetweenCurrentRow

WindowRowsAndStep<T> rowsBetweenCurrentRow()

Add a ROWS BETWEEN CURRENT ROW ... frame clause to the window function.

rowsBetweenUnboundedFollowing

WindowRowsAndStep<T> rowsBetweenUnboundedFollowing()

Add a ROWS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window function.

rowsBetweenFollowing

WindowRowsAndStep<T> rowsBetweenFollowing(int number)

Add a ROWS BETWEEN [number] FOLLOWING ... frame clause to the window function.