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 |
CaseConditionStep<T>
The final step in creating a case statement of the type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
|
interface |
CaseWhenStep<V,T>
The final step in creating a case statement of the type
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
|
interface |
Field<T>
A field used in tables and conditions
Note that all fields qualify as
GroupField , i.e. they can always be
used in GROUP BY clauses |
interface |
GroupConcatOrderByStep
MySQL's
GROUP_CONCAT function. |
interface |
GroupConcatSeparatorStep
MySQL's
GROUP_CONCAT function. |
interface |
Param<T>
A named parameter and/or bind value.
|
interface |
TableField<R extends Record,T>
A field contained in a table
|
interface |
UDTField<R extends UDTRecord<R>,T>
A field contained in a UDT
|
interface |
WindowBeforeOverStep<T>
This type is used for the window function DSL API.
|
interface |
WindowFinalStep<T>
This type is used for the window function DSL API.
|
interface |
WindowOrderByStep<T>
This type is used for the window function DSL API.
|
interface |
WindowPartitionByStep<T>
This type is used for the window function DSL API.
|
interface |
WindowRowsStep<T>
This type is used for the window function DSL API.
|
Modifier and Type | Method and Description |
---|---|
void |
SelectQuery.addGroupBy(GroupField... fields)
Adds grouping fields.
|
SelectHavingStep<R> |
SelectGroupByStep.groupBy(GroupField... fields)
Add a
GROUP BY clause to the query
Calling this with an empty argument list will result in an empty
GROUP BY () clause being rendered. |
Modifier and Type | Method and Description |
---|---|
void |
SelectQuery.addGroupBy(Collection<? extends GroupField> fields)
Adds grouping fields.
|
SelectHavingStep<R> |
SelectGroupByStep.groupBy(Collection<? extends GroupField> fields)
Add a
GROUP BY clause to the query
Calling this with an empty argument list will result in an empty
GROUP BY () clause being rendered. |
Modifier and Type | Class and Description |
---|---|
class |
CustomField<T>
A base class for custom
Field implementations in client code. |
class |
Iif<T> |
class |
NullIf<T> |
Modifier and Type | Method and Description |
---|---|
static GroupField |
DSL.cube(Field<?>... fields)
Create a CUBE(field1, field2, .., fieldn) grouping field.
|
static GroupField |
DSL.cube(FieldOrRow... fields)
Create a CUBE(field1, field2, .., fieldn) grouping field.
|
static GroupField |
DSL.groupingSets(Collection<? extends Field<?>>... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field.
|
static GroupField |
DSL.groupingSets(Field<?>... fields)
Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where
each grouping set only consists of a single field.
|
static GroupField |
DSL.groupingSets(Field<?>[]... fieldSets)
Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field.
|
static GroupField |
DSL.rollup(Field<?>... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.
|
static GroupField |
DSL.rollup(FieldOrRow... fields)
Create a ROLLUP(field1, field2, .., fieldn) grouping field.
|
Copyright © 2019. All rights reserved.