T
- The function return typepublic interface WindowRowsStep<T> extends WindowFinalStep<T>
Example:
field.firstValue()
.ignoreNulls()
.over()
.partitionBy(AUTHOR_ID)
.orderBy(PUBLISHED_IN.asc())
.rowsBetweenUnboundedPreceding()
.andUnboundedFollowing()
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. |
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, compare, compare, compare, compare, 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, 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, getQualifiedName, getType, getUnqualifiedName, 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, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, 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, 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, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, 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
@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rowsUnboundedPreceding()
ROWS UNBOUNDED PRECEDING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rowsPreceding(int number)
ROWS [number] PRECEDING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rowsCurrentRow()
ROWS CURRENT ROW
frame clause to the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rowsUnboundedFollowing()
ROWS UNBOUNDED FOLLOWING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rowsFollowing(int number)
ROWS [number] FOLLOWING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rowsBetweenUnboundedPreceding()
ROWS BETWEEN UNBOUNDED PRECEDING ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rowsBetweenPreceding(int number)
ROWS BETWEEN [number] PRECEDING ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rowsBetweenCurrentRow()
ROWS BETWEEN CURRENT ROW ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rowsBetweenUnboundedFollowing()
ROWS BETWEEN UNBOUNDED FOLLOWING ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,REDSHIFT,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rowsBetweenFollowing(int number)
ROWS BETWEEN [number] FOLLOWING ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rangeUnboundedPreceding()
RANGE UNBOUNDED PRECEDING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rangePreceding(int number)
RANGE [number] PRECEDING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rangeCurrentRow()
RANGE CURRENT ROW
frame clause to the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rangeUnboundedFollowing()
RANGE UNBOUNDED FOLLOWING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowFinalStep<T> rangeFollowing(int number)
RANGE [number] FOLLOWING
frame clause to the window
function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rangeBetweenUnboundedPreceding()
RANGE BETWEEN UNBOUNDED PRECEDING ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rangeBetweenPreceding(int number)
RANGE BETWEEN [number] PRECEDING ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rangeBetweenCurrentRow()
RANGE BETWEEN CURRENT ROW ...
frame clause to
the window function.@Support(value={DB2,POSTGRES,INFORMIX,MYSQL_8_0,ORACLE,SQLSERVER2012,SYBASE,VERTICA}) WindowRowsAndStep<T> rangeBetweenUnboundedFollowing()
RANGE BETWEEN UNBOUNDED FOLLOWING ...
frame clause to
the window function.Copyright © 2018. All Rights Reserved.