org.jooq

public Interface CommonTableExpression<R extends org.jooq.Record>

Known Direct Implementers: org.jooq.impl.CommonTableExpressionImpl
Imports: org.jooq.impl.QOM, .QOM.Materialized, org.jetbrains.annotations.NotNull, .Nullable, .ApiStatus.Experimental

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 Summary

Modifier and Type	Method and Description
public @NotNull DerivedColumnList	$derivedColumnList() Experimental query object model accessor method, see also `QOM`.
public @Nullable QOM.Materialized	$materialized() Experimental query object model accessor method, see also `QOM`.
public @NotNull ResultQuery<R>	$query() Experimental query object model accessor method, see also `QOM`.

Inherited from org.jooq.Table:: as as as as as as as as as as as as as as as asterisk crossApply crossApply crossApply crossApply crossApply crossApply crossJoin crossJoin crossJoin crossJoin crossJoin crossJoin divideBy eq equal equals forceIndex forceIndexForGroupBy forceIndexForJoin forceIndexForOrderBy from fullJoin fullJoin fullJoin fullJoin fullJoin fullJoin fullOuterJoin fullOuterJoin fullOuterJoin fullOuterJoin fullOuterJoin fullOuterJoin getChecks getIdentity getIndexes getKeys getOptions getPrimaryKey getRecordTimestamp getRecordVersion getReferences getReferencesFrom getReferencesTo getTableType getUniqueKeys ignoreIndex ignoreIndexForGroupBy ignoreIndexForJoin ignoreIndexForOrderBy innerJoin innerJoin innerJoin innerJoin innerJoin innerJoin join join join join join join join leftAntiJoin leftJoin leftJoin leftJoin leftJoin leftJoin leftJoin leftOuterJoin leftOuterJoin leftOuterJoin leftOuterJoin leftOuterJoin leftOuterJoin leftSemiJoin naturalFullOuterJoin naturalFullOuterJoin naturalFullOuterJoin naturalFullOuterJoin naturalFullOuterJoin naturalFullOuterJoin naturalJoin naturalJoin naturalJoin naturalJoin naturalJoin naturalJoin naturalLeftOuterJoin naturalLeftOuterJoin naturalLeftOuterJoin naturalLeftOuterJoin naturalLeftOuterJoin naturalLeftOuterJoin naturalRightOuterJoin naturalRightOuterJoin naturalRightOuterJoin naturalRightOuterJoin naturalRightOuterJoin naturalRightOuterJoin ne notEqual outerApply outerApply outerApply outerApply outerApply outerApply recordType rightJoin rightJoin rightJoin rightJoin rightJoin rightJoin rightOuterJoin rightOuterJoin rightOuterJoin rightOuterJoin rightOuterJoin rightOuterJoin rowid straightJoin straightJoin straightJoin straightJoin straightJoin straightJoin useIndex useIndexForGroupBy useIndexForJoin useIndexForOrderBy where where where where where where where where whereExists whereNotExists withOrdinality

Method Detail

$derivedColumnList back to summary

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

public @NotNull DerivedColumnList $derivedColumnList()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

Annotations

@Experimental
@NotNull

$materialized back to summary

$materialized	back to summary
public @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. Annotations @Experimental @Nullable

public @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.

Annotations

@Experimental
@Nullable

$query back to summary

$query	back to summary
public @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. Annotations @Experimental @NotNull

public @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.

Annotations

@Experimental
@NotNull