-
- All Superinterfaces:
Named
,QueryPart
,Serializable
,Table<R>
,TableLike<R>
public interface CommonTableExpression<R extends Record> extends Table<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(Select)
.- Author:
- Lukas Eder
-
-
Method Summary
-
Methods inherited from interface org.jooq.Named
getName, getQualifiedName, getUnqualifiedName
-
Methods inherited from interface org.jooq.Table
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, forceIndex, forceIndexForGroupBy, forceIndexForJoin, forceIndexForOrderBy, from, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, getCatalog, getComment, getDataType, getIdentity, getIndexes, getKeys, getPrimaryKey, getRecordTimestamp, getRecordType, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getSchema, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, join, join, leftAntiJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftSemiJoin, 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, newRecord, notEqual, outerApply, outerApply, outerApply, outerApply, outerApply, outerApply, partitionBy, partitionBy, pivot, pivot, recordType, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rowid, 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
-
-