Uses of Interface
org.jooq.WindowOverStep
-
Packages that use WindowOverStep Package Description org.jooq Theorg.jooqpackage contains jOOQ's public API.org.jooq.impl Theorg.jooq.implpackage contains jOOQ's implementation classes. -
-
Uses of WindowOverStep in org.jooq
Subinterfaces of WindowOverStep in org.jooq Modifier and Type Interface Description interfaceAggregateFilterStep<T>The step in the specification of aggregate functions where the SQL:2003 standardFILTER clausecan be added.interfaceAggregateFunction<T>An aggregate function.interfaceArrayAggOrderByStep<T>The SQL standardARRAY_AGG()function.interfaceGroupConcatOrderByStepMySQL'sGROUP_CONCATfunction.interfaceGroupConcatSeparatorStepMySQL'sGROUP_CONCATfunction.interfaceWindowBeforeOverStep<T>This type is used for the window function DSL API.interfaceWindowFromFirstLastStep<T>This type is used for the window function DSL API.interfaceWindowIgnoreNullsStep<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 NULLSclause to the window function.WindowOverStep<T>WindowIgnoreNullsStep. respectNulls()Add aRESPECT NULLSclause 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.
-