Module org.jooq

Package org.jooq

Interface WindowRowsStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

Field<T>, FieldOrConstraint, FieldOrRow, GroupField, Named, OrderField<T>, QueryPart, SelectField<T>, SelectFieldOrAsterisk, Serializable, Typed<T>, 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	Description
WindowRowsAndStep<T>	groupsBetweenCurrentRow()	Add a GROUPS BETWEEN CURRENT ROW ... frame clause to the window function.
WindowRowsAndStep<T>	groupsBetweenFollowing(int number)	Add a GROUPS BETWEEN [number] FOLLOWING ... frame clause to the window function.
WindowRowsAndStep<T>	groupsBetweenPreceding(int number)	Add a GROUPS BETWEEN [number] PRECEDING ... frame clause to the window function.
WindowRowsAndStep<T>	groupsBetweenUnboundedFollowing()	Add a GROUPS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window function.
WindowRowsAndStep<T>	groupsBetweenUnboundedPreceding()	Add a GROUPS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window function.
WindowExcludeStep<T>	groupsCurrentRow()	Add a GROUPS CURRENT ROW frame clause to the window function.
WindowExcludeStep<T>	groupsFollowing(int number)	Add a GROUPS [number] FOLLOWING frame clause to the window function.
WindowExcludeStep<T>	groupsPreceding(int number)	Add a GROUPS [number] PRECEDING frame clause to the window function.
WindowExcludeStep<T>	groupsUnboundedFollowing()	Add a GROUPS UNBOUNDED FOLLOWING frame clause to the window function.
WindowExcludeStep<T>	groupsUnboundedPreceding()	Add a GROUPS UNBOUNDED PRECEDING frame clause to the window function.
WindowRowsAndStep<T>	rangeBetweenCurrentRow()	Add a RANGE BETWEEN CURRENT ROW ... frame clause to the window function.
WindowRowsAndStep<T>	rangeBetweenFollowing(int number)	Add a RANGE BETWEEN [number] FOLLOWING ... frame clause to the window function.
WindowRowsAndStep<T>	rangeBetweenPreceding(int number)	Add a RANGE BETWEEN [number] PRECEDING ... frame clause to the window function.
WindowRowsAndStep<T>	rangeBetweenUnboundedFollowing()	Add a RANGE BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window function.
WindowRowsAndStep<T>	rangeBetweenUnboundedPreceding()	Add a RANGE BETWEEN UNBOUNDED PRECEDING ... frame clause to the window function.
WindowExcludeStep<T>	rangeCurrentRow()	Add a RANGE CURRENT ROW frame clause to the window function.
WindowExcludeStep<T>	rangeFollowing(int number)	Add a RANGE [number] FOLLOWING frame clause to the window function.
WindowExcludeStep<T>	rangePreceding(int number)	Add a RANGE [number] PRECEDING frame clause to the window function.
WindowExcludeStep<T>	rangeUnboundedFollowing()	Add a RANGE UNBOUNDED FOLLOWING frame clause to the window function.
WindowExcludeStep<T>	rangeUnboundedPreceding()	Add a RANGE UNBOUNDED PRECEDING frame clause to the window function.
WindowRowsAndStep<T>	rowsBetweenCurrentRow()	Add a ROWS BETWEEN CURRENT ROW ... frame clause to the window function.
WindowRowsAndStep<T>	rowsBetweenFollowing(int number)	Add a ROWS BETWEEN [number] FOLLOWING ... frame clause to the window function.
WindowRowsAndStep<T>	rowsBetweenPreceding(int number)	Add a ROWS BETWEEN [number] PRECEDING ... frame clause to the window function.
WindowRowsAndStep<T>	rowsBetweenUnboundedFollowing()	Add a ROWS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window function.
WindowRowsAndStep<T>	rowsBetweenUnboundedPreceding()	Add a ROWS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window function.
WindowExcludeStep<T>	rowsCurrentRow()	Add a ROWS CURRENT ROW frame clause to the window function.
WindowExcludeStep<T>	rowsFollowing(int number)	Add a ROWS [number] FOLLOWING frame clause to the window function.
WindowExcludeStep<T>	rowsPreceding(int number)	Add a ROWS [number] PRECEDING frame clause to the window function.
WindowExcludeStep<T>	rowsUnboundedFollowing()	Add a ROWS UNBOUNDED FOLLOWING frame clause to the window function.
WindowExcludeStep<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, 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, collate, collate, collate, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotJson, 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, 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, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rad, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, similarTo, similarTo, similarTo, similarTo, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.Named

getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Methods inherited from interface org.jooq.Typed

getBinding, getConverter, getDataType, getDataType, getType

Method Detail

rowsUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rowsUnboundedPreceding()

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

rowsPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rowsPreceding(int number)

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

rowsCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rowsCurrentRow()

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

rowsUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rowsUnboundedFollowing()

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

rowsFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rowsFollowing(int number)

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

rowsBetweenUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rowsBetweenUnboundedPreceding()

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

rowsBetweenPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rowsBetweenPreceding(int number)

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

rowsBetweenCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rowsBetweenCurrentRow()

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

rowsBetweenUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rowsBetweenUnboundedFollowing()

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

rowsBetweenFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rowsBetweenFollowing(int number)

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

rangeUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rangeUnboundedPreceding()

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

rangePreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rangePreceding(int number)

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

rangeCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rangeCurrentRow()

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

rangeUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rangeUnboundedFollowing()

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

rangeFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowExcludeStep<T> rangeFollowing(int number)

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

rangeBetweenUnboundedPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rangeBetweenUnboundedPreceding()

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

rangeBetweenPreceding

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rangeBetweenPreceding(int number)

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

rangeBetweenCurrentRow

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rangeBetweenCurrentRow()

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

rangeBetweenUnboundedFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rangeBetweenUnboundedFollowing()

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

rangeBetweenFollowing

@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,VERTICA})
WindowRowsAndStep<T> rangeBetweenFollowing(int number)

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

groupsUnboundedPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowExcludeStep<T> groupsUnboundedPreceding()

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

groupsPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowExcludeStep<T> groupsPreceding(int number)

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

groupsCurrentRow

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowExcludeStep<T> groupsCurrentRow()

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

groupsUnboundedFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowExcludeStep<T> groupsUnboundedFollowing()

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

groupsFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowExcludeStep<T> groupsFollowing(int number)

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

groupsBetweenUnboundedPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowRowsAndStep<T> groupsBetweenUnboundedPreceding()

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

groupsBetweenPreceding

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowRowsAndStep<T> groupsBetweenPreceding(int number)

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

groupsBetweenCurrentRow

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowRowsAndStep<T> groupsBetweenCurrentRow()

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

groupsBetweenUnboundedFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowRowsAndStep<T> groupsBetweenUnboundedFollowing()

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

groupsBetweenFollowing

@Support({COCKROACHDB,H2,POSTGRES_11,SQLITE_3_28})
WindowRowsAndStep<T> groupsBetweenFollowing(int number)

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