org.jooq

Interface WindowRowsStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

Field<T>, FieldOrRow, GroupField, QueryPart, SelectField<T>, 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

Modifier and Type	Method and Description
WindowRowsAndStep<T>	rangeBetweenCurrentRow() Add a RANGE BETWEEN CURRENT ROW ...
WindowRowsAndStep<T>	rangeBetweenFollowing(int number) Add a RANGE BETWEEN [number] FOLLOWING ...
WindowRowsAndStep<T>	rangeBetweenPreceding(int number) Add a RANGE BETWEEN [number] PRECEDING ...
WindowRowsAndStep<T>	rangeBetweenUnboundedFollowing() Add a RANGE BETWEEN UNBOUNDED FOLLOWING ...
WindowRowsAndStep<T>	rangeBetweenUnboundedPreceding() Add a RANGE BETWEEN UNBOUNDED PRECEDING ...
WindowFinalStep<T>	rangeCurrentRow() Add a RANGE CURRENT ROW frame clause to the window function.
WindowFinalStep<T>	rangeFollowing(int number) Add a RANGE [number] FOLLOWING frame clause to the window function.
WindowFinalStep<T>	rangePreceding(int number) Add a RANGE [number] PRECEDING frame clause to the window function.
WindowFinalStep<T>	rangeUnboundedFollowing() Add a RANGE UNBOUNDED FOLLOWING frame clause to the window function.
WindowFinalStep<T>	rangeUnboundedPreceding() Add a RANGE UNBOUNDED PRECEDING frame clause to the window function.
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, 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

Method Detail

rowsUnboundedPreceding

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

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

rowsPreceding

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

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

rowsCurrentRow

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

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

rowsUnboundedFollowing

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

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

rowsFollowing

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

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

rowsBetweenUnboundedPreceding

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

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

rowsBetweenPreceding

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

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

rowsBetweenCurrentRow

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

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

rowsBetweenUnboundedFollowing

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

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

rowsBetweenFollowing

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

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

rangeUnboundedPreceding

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

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

rangePreceding

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

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

rangeCurrentRow

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

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

rangeUnboundedFollowing

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

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

rangeFollowing

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

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

rangeBetweenUnboundedPreceding

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

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

rangeBetweenPreceding

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

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

rangeBetweenCurrentRow

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

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

rangeBetweenUnboundedFollowing

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

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

rangeBetweenFollowing

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

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