|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
R
- The record type being returned by this querypublic interface SimpleSelectOrderByStep<R extends Record>
This type is used for the Select
's DSL API when selecting specific
Record
types.
Example:
Refer to the manual for more details
create.selectFrom(T_AUTHOR)
.where(TBook.LANGUAGE.equal("DE"))
.and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
.orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
.limit(2)
.offset(1)
.forUpdate()
.of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.noWait();
Method Summary | |
---|---|
SimpleSelectLimitStep<R> |
orderBy(Collection<SortField<?>> fields)
Add an ORDER BY clause to the query |
SimpleSelectLimitStep<R> |
orderBy(Field<?>... fields)
Add an ORDER BY clause to the query |
SimpleSelectLimitStep<R> |
orderBy(int... fieldIndexes)
Add an ORDER BY clause to the query
Indexes start at 1 in SQL! |
SimpleSelectLimitStep<R> |
orderBy(SortField<?>... fields)
Add an ORDER BY clause to the query |
SimpleSelectLimitStep<R> |
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. |
SimpleSelectLimitStep<R> |
orderSiblingsBy(Field<?>... 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. |
SimpleSelectLimitStep<R> |
orderSiblingsBy(int... fieldIndexes)
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. |
SimpleSelectLimitStep<R> |
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. |
Methods inherited from interface org.jooq.SimpleSelectLimitStep |
---|
limit, limit, limit, limit, limit, limit |
Methods inherited from interface org.jooq.SimpleSelectForUpdateStep |
---|
forShare, forUpdate |
Methods inherited from interface org.jooq.SimpleSelectFinalStep |
---|
getQuery |
Methods inherited from interface org.jooq.Select |
---|
except, getSelect, intersect, union, unionAll |
Methods inherited from interface org.jooq.ResultQuery |
---|
bind, bind, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLater, fetchLater, fetchLazy, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneMap, fetchResultSet, getRecordType, getResult |
Methods inherited from interface org.jooq.Query |
---|
execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable |
Methods inherited from interface org.jooq.QueryPart |
---|
attach |
Methods inherited from interface org.jooq.Adapter |
---|
internalAPI |
Methods inherited from interface org.jooq.TableLike |
---|
asTable, asTable |
Methods inherited from interface org.jooq.FieldLike |
---|
asField, asField |
Methods inherited from interface org.jooq.FieldProvider |
---|
getField, getField, getField, getFields, getIndex |
Method Detail |
---|
SimpleSelectLimitStep<R> orderBy(Field<?>... fields)
ORDER BY
clause to the query
SimpleSelectLimitStep<R> orderBy(SortField<?>... fields)
ORDER BY
clause to the query
SimpleSelectLimitStep<R> orderBy(Collection<SortField<?>> fields)
ORDER BY
clause to the query
SimpleSelectLimitStep<R> orderBy(int... fieldIndexes)
ORDER BY
clause to the query
Indexes start at 1
in SQL!
Note, you can use orderBy(Factory.val(1).desc())
or
orderBy(Factory.literal(1).desc())
to apply descending
ordering
SimpleSelectLimitStep<R> orderSiblingsBy(Field<?>... fields)
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.
SimpleSelectLimitStep<R> orderSiblingsBy(SortField<?>... fields)
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.
SimpleSelectLimitStep<R> orderSiblingsBy(Collection<SortField<?>> fields)
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.
SimpleSelectLimitStep<R> orderSiblingsBy(int... fieldIndexes)
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.
Indexes start at 1
in SQL!
Note, you can use orderSiblingsBy(Factory.val(1).desc())
or
orderBy(Factory.literal(1).desc())
to apply descending
ordering
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |