Uses of Interface
org.jooq.WindowOverStep
-
Packages that use WindowOverStep Package Description org.jooq Theorg.jooq
package contains jOOQ's public API.org.jooq.impl Theorg.jooq.impl
package contains jOOQ's implementation classes. -
-
Uses of WindowOverStep in org.jooq
Subinterfaces of WindowOverStep in org.jooq Modifier and Type Interface Description interface
AggregateFilterStep<T>
The step in the specification of aggregate functions where the SQL:2003 standardFILTER clause
can be added.interface
AggregateFunction<T>
An aggregate function.interface
ArrayAggOrderByStep<T>
The SQL standardARRAY_AGG()
function.interface
GroupConcatOrderByStep
MySQL'sGROUP_CONCAT
function.interface
GroupConcatSeparatorStep
MySQL'sGROUP_CONCAT
function.interface
WindowBeforeOverStep<T>
This type is used for the window function DSL API.interface
WindowFromFirstLastStep<T>
This type is used for the window function DSL API.interface
WindowIgnoreNullsStep<T>
This type is used for the window function DSL API.Methods in org.jooq that return WindowOverStep Modifier and Type Method Description WindowOverStep<T>
WindowIgnoreNullsStep. ignoreNulls()
Add anIGNORE NULLS
clause to the window function.WindowOverStep<T>
WindowIgnoreNullsStep. respectNulls()
Add aRESPECT NULLS
clause to the window function. -
Uses of WindowOverStep in org.jooq.impl
Methods in org.jooq.impl that return WindowOverStep Modifier and Type Method Description static WindowOverStep<BigDecimal>
DSL. cumeDist()
Thecume_dist() over ([analytic clause])
function.static WindowOverStep<Integer>
DSL. denseRank()
Thedense_rank() over ([analytic clause])
function.static WindowOverStep<Integer>
DSL. ntile(int number)
Thentile([number]) over ([analytic clause])
function.static WindowOverStep<BigDecimal>
DSL. percentRank()
Theprecent_rank() over ([analytic clause])
function.static WindowOverStep<Integer>
DSL. rank()
Therank() over ([analytic clause])
function.static WindowOverStep<BigDecimal>
DSL. ratioToReport(Number number)
Theratio_to_report([expression]) over ([analytic clause])
function.static WindowOverStep<BigDecimal>
DSL. ratioToReport(Field<? extends Number> field)
Theratio_to_report([expression]) over ([analytic clause])
function.static WindowOverStep<Integer>
DSL. rowNumber()
Therow_number() over ([analytic clause])
function.
-