Module org.jooq
Package org.jooq

Interface CommonTableExpression<R extends Record>

All Superinterfaces:
Fields, GroupField, Named, Qualified, QueryPart, RecordQualifier<R>, 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