Module org.jooq
Package org.jooq

Interface CommonTableExpression<R extends Record>

All Superinterfaces:
Fields, 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.


 // Assuming import static org.jooq.impl.DSL.*;

 Table<?> t = name("t").fields("v").as(select(one()));


Instances can be created using Name#as(Select).

Lukas Eder