org.jooq
Interface SelectOrderByStep

All Superinterfaces:
Adapter, Attachable, FieldLike, FieldProvider, Query, QueryPart, ResultQuery<Record>, Select<Record>, SelectFinalStep, SelectForUpdateStep, SelectLimitStep, Serializable, TableLike<Record>
All Known Subinterfaces:
SelectConditionStep, SelectConnectByConditionStep, SelectConnectByStep, SelectFromStep, SelectGroupByStep, SelectHavingConditionStep, SelectHavingStep, SelectJoinStep, SelectOnConditionStep, SelectSelectStep, SelectStartWithStep, SelectWhereStep

public interface SelectOrderByStep
extends SelectLimitStep

This type is used for the Select's DSL API when selecting generic Record types.

Example:

 -- get all authors' first and last names, and the number
 -- of books they've written in German, if they have written
 -- more than five books in German in the last three years
 -- (from 2011), and sort those authors by last names
 -- limiting results to the second and third row

   SELECT T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME, COUNT(*)
     FROM T_AUTHOR
     JOIN T_BOOK ON T_AUTHOR.ID = T_BOOK.AUTHOR_ID
    WHERE T_BOOK.LANGUAGE = 'DE'
      AND T_BOOK.PUBLISHED > '2008-01-01'
 GROUP BY T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME
   HAVING COUNT(*) > 5
 ORDER BY T_AUTHOR.LAST_NAME ASC NULLS FIRST
    LIMIT 2
   OFFSET 1
      FOR UPDATE
       OF FIRST_NAME, LAST_NAME
       NO WAIT
 
Its equivalent in jOOQ
 create.select(TAuthor.FIRST_NAME, TAuthor.LAST_NAME, create.count())
       .from(T_AUTHOR)
       .join(T_BOOK).on(TBook.AUTHOR_ID.equal(TAuthor.ID))
       .where(TBook.LANGUAGE.equal("DE"))
       .and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
       .groupBy(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
       .having(create.count().greaterThan(5))
       .orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
       .limit(2)
       .offset(1)
       .forUpdate()
       .of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
       .noWait();
 
Refer to the manual for more details

Author:
Lukas Eder

Method Summary
 SelectLimitStep orderBy(Collection<SortField<?>> fields)
          Add an ORDER BY clause to the query
 SelectLimitStep orderBy(Field<?>... fields)
          Add an ORDER BY clause to the query
 SelectLimitStep orderBy(int... fieldIndexes)
          Add an ORDER BY clause to the query Indexes start at 1 in SQL!
 SelectLimitStep orderBy(SortField<?>... fields)
          Add an ORDER BY clause to the query
 SelectLimitStep 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 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.
 SelectLimitStep 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.
 SelectLimitStep 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.SelectLimitStep
limit, limit, limit, limit, limit, limit
 
Methods inherited from interface org.jooq.SelectForUpdateStep
forShare, forUpdate
 
Methods inherited from interface org.jooq.SelectFinalStep
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

orderBy

SelectLimitStep orderBy(Field<?>... fields)
Add an ORDER BY clause to the query


orderBy

SelectLimitStep orderBy(SortField<?>... fields)
Add an ORDER BY clause to the query


orderBy

SelectLimitStep orderBy(Collection<SortField<?>> fields)
Add an ORDER BY clause to the query


orderBy

SelectLimitStep orderBy(int... fieldIndexes)
Add an 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


orderSiblingsBy

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


orderSiblingsBy

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


orderSiblingsBy

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


orderSiblingsBy

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

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



Copyright © 2012. All Rights Reserved.