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.

    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