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.