- All Superinterfaces:
Fields
,GroupField
,Named
,Qualified
,QueryPart
,RecordQualifier<R>
,SelectField<R>
,SelectFieldOrAsterisk
,Serializable
,Table<R>
,TableLike<R>
,Typed<R>
A common table expression.
A common table expression is a table that can be supplied to
WITH
clauses. It may or may not be defined recursively.
Example:
// Assuming import static org.jooq.impl.DSL.*;
Table<?> t = name("t").fields("v").as(select(one()));
using(configuration)
.select()
.from(t)
.fetch();
Instances can be created using Name.as(ResultQuery)
.
- Author:
- Lukas Eder
-
Method Summary
Modifier and TypeMethodDescription@NotNull DerivedColumnList
Experimental query object model accessor method, see alsoQOM
.@Nullable QOM.Materialized
Experimental query object model accessor method, see alsoQOM
.@NotNull ResultQuery<R>
$query()
Experimental query object model accessor method, see alsoQOM
.Methods inherited from interface org.jooq.Fields
dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types
Methods inherited from interface org.jooq.Named
$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName
Methods inherited from interface org.jooq.Qualified
$schema, getCatalog, getSchema
Methods inherited from interface org.jooq.QueryPart
$replace, $replace, $traverse, $traverse, hashCode, toString
Methods inherited from interface org.jooq.RecordQualifier
getDataType, getPackage, getRecordType, newRecord
Methods inherited from interface org.jooq.SelectField
as, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo
Methods inherited from interface org.jooq.Table
as, as, as, as, as, as, as, as, as, as, as, as, as, as, as, asOfScn, asOfScn, asOfTimestamp, asOfTimestamp, asterisk, at, at, at, crossApply, crossApply, crossApply, crossApply, crossApply, crossApply, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, divideBy, eq, equal, equals, for_, forceIndex, forceIndexForGroupBy, forceIndexForJoin, forceIndexForOrderBy, forPortionOf, from, fullHashJoin, fullHashJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullLoopJoin, fullLoopJoin, fullMergeJoin, fullMergeJoin, fullOuterHashJoin, fullOuterHashJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterLoopJoin, fullOuterLoopJoin, fullOuterMergeJoin, fullOuterMergeJoin, getChecks, getIdentity, getIndexes, getKeys, getOptions, getPrimaryKey, getRecordTimestamp, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getTableType, getTriggers, getUniqueKeys, hashJoin, hashJoin, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerHashJoin, innerHashJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerLoopJoin, innerLoopJoin, innerMergeJoin, innerMergeJoin, join, join, join, join, join, join, join, join, join, leftAntiJoin, leftAntiJoin, leftHashJoin, leftHashJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftLoopJoin, leftLoopJoin, leftMergeJoin, leftMergeJoin, leftOuterHashJoin, leftOuterHashJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterLoopJoin, leftOuterLoopJoin, leftOuterMergeJoin, leftOuterMergeJoin, leftSemiJoin, leftSemiJoin, loopJoin, loopJoin, mergeJoin, mergeJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, ne, notEqual, outerApply, outerApply, outerApply, outerApply, outerApply, outerApply, partitionBy, partitionBy, pivot, pivot, pivot, recordType, rightHashJoin, rightHashJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightLoopJoin, rightLoopJoin, rightMergeJoin, rightMergeJoin, rightOuterHashJoin, rightOuterHashJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterLoopJoin, rightOuterLoopJoin, rightOuterMergeJoin, rightOuterMergeJoin, rowid, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, useIndex, useIndexForGroupBy, useIndexForJoin, useIndexForOrderBy, versionsBetweenScn, versionsBetweenScn, versionsBetweenScnMinvalue, versionsBetweenTimestamp, versionsBetweenTimestamp, versionsBetweenTimestampMinvalue, where, where, where, where, where, where, where, where, whereExists, whereNotExists, with, with, with, with, withOrdinality
Methods inherited from interface org.jooq.TableLike
asMultiset, asMultiset, asMultiset, asMultiset, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable
Methods inherited from interface org.jooq.Typed
$dataType, getBinding, getConverter, getDataType, getDataType, getType
-
Method Details
-
$derivedColumnList
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$query
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk. -
$materialized
Experimental query object model accessor method, see alsoQOM
. Subject to change in future jOOQ versions, use at your own risk.
-