Uses of Interface
org.jooq.CommonTableExpression

Packages that use CommonTableExpression

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of CommonTableExpression in org.jooq

Methods in org.jooq that return CommonTableExpression

Modifier and Type	Method	Description
<R extends Record> @NotNull CommonTableExpression<R>	DerivedColumnList.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList10.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList11.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList12.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList13.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList14.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList15.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList16.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList17.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList18.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList19.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record2<?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList2.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList20.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList21.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList22.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record3<?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList3.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record4<?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList4.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record6<?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList6.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record7<?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList7.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList8.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList9.as(ResultQuery<R> query)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	Name.as(ResultQuery<R> query)	Specify a subselect to refer to by the Name to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	DerivedColumnList.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList10.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList11.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList12.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList13.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList14.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList15.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList16.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList17.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList18.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList19.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record2<?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList2.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList20.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList21.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList22.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record3<?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList3.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record4<?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList4.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record6<?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList6.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record7<?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList7.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList8.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList9.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	Name.asMaterialized(ResultQuery<R> query)	Specify a materialized subselect to refer to by the Name to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	DerivedColumnList.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record1<?>> @NotNull CommonTableExpression<R>	DerivedColumnList1.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList10.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList11.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList12.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList13.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList14.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList15.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList16.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList17.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList18.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList19.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record2<?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList2.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList20.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList21.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList22.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record3<?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList3.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record4<?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList4.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record5<?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList5.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record6<?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList6.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record7<?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList7.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList8.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> @NotNull CommonTableExpression<R>	DerivedColumnList9.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.
<R extends Record> @NotNull CommonTableExpression<R>	Name.asNotMaterialized(ResultQuery<R> query)	Specify a non-materialized subselect to refer to by the Name to form a common table expression.

Methods in org.jooq with parameters of type CommonTableExpression

Modifier and Type	Method	Description
@NotNull WithStep	DSLContext.with(CommonTableExpression<?>... tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
@NotNull WithStep	WithStep.with(CommonTableExpression<?>... tables)	Add another common table expression to the WITH clause.
@NotNull WithStep	DSLContext.withRecursive(CommonTableExpression<?>... tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

Method parameters in org.jooq with type arguments of type CommonTableExpression

Modifier and Type	Method	Description
@NotNull WithStep	DSLContext.with(Collection<? extends CommonTableExpression<?>> tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
@NotNull WithStep	WithStep.with(Collection<? extends CommonTableExpression<?>> tables)	Add another common table expression to the WITH clause.
@NotNull WithStep	DSLContext.withRecursive(Collection<? extends CommonTableExpression<?>> tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

Uses of CommonTableExpression in org.jooq.impl

Methods in org.jooq.impl with parameters of type CommonTableExpression

Modifier and Type	Method	Description
WithStep	DefaultDSLContext.with(CommonTableExpression<?>... tables)
static @NotNull WithStep	DSL.with(CommonTableExpression<?>... tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
WithStep	DefaultDSLContext.withRecursive(CommonTableExpression<?>... tables)
static @NotNull WithStep	DSL.withRecursive(CommonTableExpression<?>... tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.

Method parameters in org.jooq.impl with type arguments of type CommonTableExpression

Modifier and Type	Method	Description
WithStep	DefaultDSLContext.with(Collection<? extends CommonTableExpression<?>> tables)
static @NotNull WithStep	DSL.with(Collection<? extends CommonTableExpression<?>> tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.
WithStep	DefaultDSLContext.withRecursive(Collection<? extends CommonTableExpression<?>> tables)
static @NotNull WithStep	DSL.withRecursive(Collection<? extends CommonTableExpression<?>> tables)	Create a WITH clause to supply subsequent SELECT, UPDATE, INSERT, DELETE, and MERGE statements with CommonTableExpressions.