Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
Modifier and Type | Interface and Description |
---|---|
interface |
AggregateFilterStep<T>
The step in the specification of aggregate functions where the SQL:2003
standard
FILTER clause can be added. |
interface |
AggregateFunction<T>
An aggregate function is a special field that is usually used in a
GROUP BY context. |
interface |
ArrayAggOrderByStep<T>
The SQL standard
ARRAY_AGG() function. |
interface |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
interface |
WindowBeforeOverStep<T>
This type is used for the window function DSL API.
|
interface |
WindowIgnoreNullsStep<T>
This type is used for the window function DSL API.
|
Modifier and Type | Method and Description |
---|---|
WindowOverStep<T> |
WindowIgnoreNullsStep.ignoreNulls()
Add an
IGNORE NULLS clause to the window function. |
WindowOverStep<T> |
WindowIgnoreNullsStep.respectNulls()
Add a
RESPECT NULLS clause to the window function. |
Modifier and Type | Method and Description |
---|---|
static WindowOverStep<BigDecimal> |
DSL.cumeDist()
The
cume_dist() over ([analytic clause]) function. |
static WindowOverStep<Integer> |
DSL.denseRank()
The
dense_rank() over ([analytic clause]) function. |
static WindowOverStep<Integer> |
DSL.ntile(int number)
The
ntile([number]) over ([analytic clause]) function. |
static WindowOverStep<BigDecimal> |
DSL.percentRank()
The
precent_rank() over ([analytic clause]) function. |
static WindowOverStep<Integer> |
DSL.rank()
The
rank() over ([analytic clause]) function. |
static WindowOverStep<Integer> |
DSL.rowNumber()
The
row_number() over ([analytic clause]) function. |
Copyright © 2016. All Rights Reserved.