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
  • Method Details

    • $derivedColumnList

      @Experimental @NotNull @NotNull DerivedColumnList $derivedColumnList()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $query

      @Experimental @NotNull @NotNull ResultQuery<R> $query()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.
    • $materialized

      @Experimental @Nullable @Nullable QOM.Materialized $materialized()
      Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.