Module org.jooq
Package org.jooq

Interface CommonTableExpression<R extends Record>

  • 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.


     // Assuming import static org.jooq.impl.DSL.*;
     Table<?> t = name("t").fields("v").as(select(one()));

    Instances can be created using

    Lukas Eder