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

All Methods Instance Methods Abstract Methods
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, 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, 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.Typed
getBinding, getConverter, getDataType, getDataType, getType

Method Detail

rowsUnboundedPreceding

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,COCKROACHDB,DB2,H2,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,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,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,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,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,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,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,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,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,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,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,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.

Interface WindowRowsStep<T>