public interface SelectFromStep<R extends Record> extends SelectWhereStep<R>
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
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();
| Modifier and Type | Method and Description |
|---|---|
SelectJoinStep<R> |
from(Collection<? extends TableLike<?>> tables)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
from(String sql)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
from(String sql,
Object... bindings)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
from(String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
SelectJoinStep<R> |
from(TableLike<?>... table)
Add a
FROM clause to the query. |
SelectFromStep<R> |
hint(String hint)
Add an Oracle-style hint to the preceding select clause.
|
where, where, where, where, where, where, whereExists, whereNotExistsconnectBy, connectBy, connectBy, connectBy, connectBy, connectByNoCycle, connectByNoCycle, connectByNoCycle, connectByNoCycle, connectByNoCyclegroupBy, groupByhaving, having, having, having, having, havingwindow, windoworderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderSiblingsBy, orderSiblingsBy, orderSiblingsBy, orderSiblingsByforShare, forUpdateoptiongetQueryexcept, fetchCount, getSelect, intersect, union, unionAllbind, bind, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLater, fetchLater, fetchLazy, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneInto, fetchOneInto, fetchOneMap, fetchResultSet, fetchSize, getRecordType, getResult, intern, intern, intern, keepStatement, maxRows, queryTimeout, resultSetConcurrency, resultSetHoldability, resultSetTypecancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutableattach, detach@Support SelectJoinStep<R> from(TableLike<?>... table)
FROM clause to the query.@Support SelectJoinStep<R> from(Collection<? extends TableLike<?>> tables)
FROM clause to the query.@Support SelectJoinStep<R> from(String sql)
FROM clause to the query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.table(String)@Support SelectJoinStep<R> from(String sql, Object... bindings)
FROM clause to the query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.table(String, Object...)@Support SelectJoinStep<R> from(String sql, QueryPart... parts)
FROM clause to the query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.table(String, QueryPart...)@Support SelectFromStep<R> hint(String hint)
Example:
DSLContext create = DSL.using(configuration);
create.select(field1, field2)
.hint("/*+ALL_ROWS*/")
.from(table1)
.fetch();
You can also use this clause for any other database, that accepts hints
or options at the same syntactic location, e.g. for MySQL's
SQL_CALC_FOUND_ROWS option:
create.select(field1, field2)
.hint("SQL_CALC_FOUND_ROWS")
.from(table1)
.fetch();
The outcome of such a query is this:
SELECT [hint] field1, field2 FROM table1
For SQL Server style table hints, see Table.with(String)
Copyright © 2014. All Rights Reserved.