org.jooq

Interface WindowOrderByStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

Field<T>, FieldOrRow, GroupField, QueryPart, SelectField<T>, Serializable, WindowFinalStep<T>

All Known Subinterfaces:

WindowPartitionByStep<T>

public interface WindowOrderByStep<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
WindowRowsStep<T>	orderBy(Collection<? extends SortField<?>> fields) Add an ORDER BY clause to the window function.
WindowRowsStep<T>	orderBy(Field<?>... fields) Add an ORDER BY clause to the window function.
WindowRowsStep<T>	orderBy(SortField<?>... fields) Add an ORDER BY clause to the window function.

Methods inherited from interface org.jooq.Field

abs, acos, add, add, 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, 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, firstValue, floor, ge, ge, ge, ge, getBinding, getComment, getConverter, getDataType, getDataType, getName, getType, 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, plus, plus, plus, position, position, pow, power, rad, repeat, repeat, replace, replace, replace, replace, 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

orderBy

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA})
WindowRowsStep<T> orderBy(Field<?>... fields)

Add an ORDER BY clause to the window function.

orderBy

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA})
WindowRowsStep<T> orderBy(SortField<?>... fields)

Add an ORDER BY clause to the window function.

orderBy

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,POSTGRES,ORACLE,REDSHIFT,SQLSERVER,SYBASE,VERTICA})
WindowRowsStep<T> orderBy(Collection<? extends SortField<?>> fields)

Add an ORDER BY clause to the window function.