Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API
This package mostly contains interfaces that are implemented by the
org.jooq.impl package. |
Modifier and Type | Method and Description |
---|---|
SortField<T> |
Field.asc()
Create an ascending sort field from this field
This is the same as calling
Field.sort(SortOrder) with
SortOrder.ASC |
SortField<T> |
Field.desc()
Create a descending sort field from this field
This is the same as calling
Field.sort(SortOrder) with
SortOrder.DESC |
SortField<T> |
SortField.nullsFirst()
Add a
NULLS FIRST clause to this sort field |
SortField<T> |
SortField.nullsLast()
Add a
NULLS LAST clause to this sort field |
<Z> SortField<Z> |
Field.sort(Map<T,Z> sortMap)
Create a sort field of the form (in pseudo code)
CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0)
WHEN [sortMap.key(1)] THEN sortMap.value(1)
... |
SortField<T> |
Field.sort(SortOrder order)
Create an ascending/descending sort field from this field
|
SortField<Integer> |
Field.sortAsc(Collection<T> sortList)
Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
... |
SortField<Integer> |
Field.sortAsc(T... sortList)
Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
... |
SortField<Integer> |
Field.sortDesc(Collection<T> sortList)
Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
... |
SortField<Integer> |
Field.sortDesc(T... sortList)
Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
... |
Modifier and Type | Method and Description |
---|---|
void |
SimpleSelectQuery.addOrderBy(SortField<?>... fields)
Adds ordering fields
|
void |
SelectQuery.addOrderBy(SortField<?>... fields)
Adds ordering fields
|
void |
OrderProvider.addOrderBy(SortField<?>... fields)
Deprecated.
Adds ordering fields
|
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankFirstOrderBy(SortField<?>... fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankLastOrderBy(SortField<?>... fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowRowsStep<T> |
WindowOrderByStep.orderBy(SortField<?>... fields)
Add an
ORDER BY clause to the window function. |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.orderBy(SortField<?>... fields)
Add an
ORDER BY clause to the query |
SelectLimitStep |
SelectOrderByStep.orderBy(SortField<?>... fields)
Add an
ORDER BY clause to the query |
GroupConcatSeparatorStep |
GroupConcatOrderByStep.orderBy(SortField<?>... fields)
Add an
ORDER BY clause to the query |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.orderSiblingsBy(SortField<?>... fields)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
SelectLimitStep |
SelectOrderByStep.orderSiblingsBy(SortField<?>... fields)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
AggregateFunction<T> |
OrderedAggregateFunction.withinGroupOrderBy(SortField<?>... fields)
Add an
WITHIN GROUP (ORDER BY ..) |
Modifier and Type | Method and Description |
---|---|
void |
SimpleSelectQuery.addOrderBy(Collection<SortField<?>> fields)
Adds ordering fields
|
void |
SelectQuery.addOrderBy(Collection<SortField<?>> fields)
Adds ordering fields
|
void |
OrderProvider.addOrderBy(Collection<SortField<?>> fields)
Deprecated.
Adds ordering fields
|
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankFirstOrderBy(Collection<SortField<?>> fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(ID) KEEP (DENSE_RANK FIRST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowBeforeOverStep<T> |
AggregateFunction.keepDenseRankLastOrderBy(Collection<SortField<?>> fields)
Restrict this aggregate function to
FIRST values
An example:
MAX(ID) KEEP (DENSE_RANK LAST ORDER BY 1)
This clause is only available on
MIN, MAX, SUM, AVG, COUNT, VARIANCE, or STDDEV functions. |
WindowRowsStep<T> |
WindowOrderByStep.orderBy(Collection<SortField<?>> fields)
Add an
ORDER BY clause to the window function. |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.orderBy(Collection<SortField<?>> fields)
Add an
ORDER BY clause to the query |
SelectLimitStep |
SelectOrderByStep.orderBy(Collection<SortField<?>> fields)
Add an
ORDER BY clause to the query |
GroupConcatSeparatorStep |
GroupConcatOrderByStep.orderBy(Collection<SortField<?>> fields)
Add an
ORDER BY clause to the query |
SimpleSelectLimitStep<R> |
SimpleSelectOrderByStep.orderSiblingsBy(Collection<SortField<?>> fields)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
SelectLimitStep |
SelectOrderByStep.orderSiblingsBy(Collection<SortField<?>> fields)
Add an
ORDER SIBLINGS BY clause to the query
This clause can be used only along with Oracle's CONNECT BY
clause, to indicate that the hierarchical ordering should be preserved
and elements of each hierarchy should be ordered among themselves. |
AggregateFunction<T> |
OrderedAggregateFunction.withinGroupOrderBy(Collection<SortField<?>> fields)
Add an
WITHIN GROUP (ORDER BY ..) |
Copyright © 2013. All Rights Reserved.