| 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.