WindowRowsStep (jOOQ 3.3.1 API)

Type Parameters:: T - The function return type

All Superinterfaces:: Field<T>, GroupField, 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()

Author:: Lukas Eder

Method Summary

Methods
Modifier and Type	Method and Description
`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, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, ceil, 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, firstValue, floor, ge, ge, ge, ge, getComment, getDataType, getDataType, getName, getType, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, 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, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, plus, plus, position, position, pow, power, rad, repeat, repeat, replace, replace, replace, replace, 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

Method Detail

rowsUnboundedPreceding

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowFinalStep<T> rowsUnboundedPreceding()

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

rowsPreceding

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowFinalStep<T> rowsPreceding(int number)

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

rowsCurrentRow

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowFinalStep<T> rowsCurrentRow()

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

rowsUnboundedFollowing

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowFinalStep<T> rowsUnboundedFollowing()

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

rowsFollowing

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowFinalStep<T> rowsFollowing(int number)

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

rowsBetweenUnboundedPreceding

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowRowsAndStep<T> rowsBetweenUnboundedPreceding()

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

rowsBetweenPreceding

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowRowsAndStep<T> rowsBetweenPreceding(int number)

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

rowsBetweenCurrentRow

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowRowsAndStep<T> rowsBetweenCurrentRow()

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

rowsBetweenUnboundedFollowing

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowRowsAndStep<T> rowsBetweenUnboundedFollowing()

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

rowsBetweenFollowing

@Support(value={DB2,POSTGRES,ORACLE,SQLSERVER2012,SYBASE})
WindowRowsAndStep<T> rowsBetweenFollowing(int number)

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

Interface WindowRowsStep<T>