Interface CommonTableExpression<R extends Record>

All Superinterfaces:
Fields, GroupField, Named, Qualified, QueryPart, RecordQualifier<R>, SelectField<R>, SelectFieldOrAsterisk, Serializable, Table<R>, TableLike<R>, Typed<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(ResultQuery).

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.