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
@NotNull WindowRowsAndStep<T>	groupsBetweenCurrentRow()	Add a GROUPS BETWEEN CURRENT ROW ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	groupsBetweenFollowing(int number)	Add a GROUPS BETWEEN [number] FOLLOWING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	groupsBetweenPreceding(int number)	Add a GROUPS BETWEEN [number] PRECEDING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	groupsBetweenUnboundedFollowing()	Add a GROUPS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	groupsBetweenUnboundedPreceding()	Add a GROUPS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window function.
@NotNull WindowExcludeStep<T>	groupsCurrentRow()	Add a GROUPS CURRENT ROW frame clause to the window function.
@NotNull WindowExcludeStep<T>	groupsFollowing(int number)	Add a GROUPS [number] FOLLOWING frame clause to the window function.
@NotNull WindowExcludeStep<T>	groupsPreceding(int number)	Add a GROUPS [number] PRECEDING frame clause to the window function.
@NotNull WindowExcludeStep<T>	groupsUnboundedFollowing()	Add a GROUPS UNBOUNDED FOLLOWING frame clause to the window function.
@NotNull WindowExcludeStep<T>	groupsUnboundedPreceding()	Add a GROUPS UNBOUNDED PRECEDING frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rangeBetweenCurrentRow()	Add a RANGE BETWEEN CURRENT ROW ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rangeBetweenFollowing(int number)	Add a RANGE BETWEEN [number] FOLLOWING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rangeBetweenPreceding(int number)	Add a RANGE BETWEEN [number] PRECEDING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rangeBetweenUnboundedFollowing()	Add a RANGE BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rangeBetweenUnboundedPreceding()	Add a RANGE BETWEEN UNBOUNDED PRECEDING ... frame clause to the window function.
@NotNull WindowExcludeStep<T>	rangeCurrentRow()	Add a RANGE CURRENT ROW frame clause to the window function.
@NotNull WindowExcludeStep<T>	rangeFollowing(int number)	Add a RANGE [number] FOLLOWING frame clause to the window function.
@NotNull WindowExcludeStep<T>	rangePreceding(int number)	Add a RANGE [number] PRECEDING frame clause to the window function.
@NotNull WindowExcludeStep<T>	rangeUnboundedFollowing()	Add a RANGE UNBOUNDED FOLLOWING frame clause to the window function.
@NotNull WindowExcludeStep<T>	rangeUnboundedPreceding()	Add a RANGE UNBOUNDED PRECEDING frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rowsBetweenCurrentRow()	Add a ROWS BETWEEN CURRENT ROW ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rowsBetweenFollowing(int number)	Add a ROWS BETWEEN [number] FOLLOWING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rowsBetweenPreceding(int number)	Add a ROWS BETWEEN [number] PRECEDING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rowsBetweenUnboundedFollowing()	Add a ROWS BETWEEN UNBOUNDED FOLLOWING ... frame clause to the window function.
@NotNull WindowRowsAndStep<T>	rowsBetweenUnboundedPreceding()	Add a ROWS BETWEEN UNBOUNDED PRECEDING ... frame clause to the window function.
@NotNull WindowExcludeStep<T>	rowsCurrentRow()	Add a ROWS CURRENT ROW frame clause to the window function.
@NotNull WindowExcludeStep<T>	rowsFollowing(int number)	Add a ROWS [number] FOLLOWING frame clause to the window function.
@NotNull WindowExcludeStep<T>	rowsPreceding(int number)	Add a ROWS [number] PRECEDING frame clause to the window function.
@NotNull WindowExcludeStep<T>	rowsUnboundedFollowing()	Add a ROWS UNBOUNDED FOLLOWING frame clause to the window function.
@NotNull 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, 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, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo, 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, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, 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

getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Methods inherited from interface org.jooq.SelectField

as, as, as

Methods inherited from interface org.jooq.Typed

getBinding, getConverter, getDataType, getDataType, getType

Method Details

rowsUnboundedPreceding

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

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

rowsPreceding

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

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

rowsCurrentRow

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

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

rowsUnboundedFollowing

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

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

rowsFollowing

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

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

rowsBetweenUnboundedPreceding

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

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

rowsBetweenPreceding

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

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

rowsBetweenCurrentRow

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

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

rowsBetweenUnboundedFollowing

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

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

rowsBetweenFollowing

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

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

rangeUnboundedPreceding

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

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

rangePreceding

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

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

rangeCurrentRow

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

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

rangeUnboundedFollowing

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

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

rangeFollowing

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

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

rangeBetweenUnboundedPreceding

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

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

rangeBetweenPreceding

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

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

rangeBetweenCurrentRow

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

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

rangeBetweenUnboundedFollowing

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

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

rangeBetweenFollowing

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

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

groupsUnboundedPreceding

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

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

groupsPreceding

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

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

groupsCurrentRow

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

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

groupsUnboundedFollowing

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

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

groupsFollowing

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

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

groupsBetweenUnboundedPreceding

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

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

groupsBetweenPreceding

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

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

groupsBetweenCurrentRow

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

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

groupsBetweenUnboundedFollowing

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

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

groupsBetweenFollowing

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

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