Module org.jooq

Package org.jooq

Interface DerivedColumnList

All Superinterfaces:

QueryPart, Serializable

public interface DerivedColumnList
extends QueryPart

A derived column list.

Thist type models a table name and an optional "derived column list", which can be used to name both tables and columns in one go, e.g. when aliasing a derived table or a CommonTableExpression.

Example:

 // Assuming import static org.jooq.impl.DSL.*;

 Table<?> t = name("t").fields("v").as(select(one()));
 //           ^^^^^^^^^^^^^^^^^^^^^ -- DerivedColumnList

 using(configuration)
    .select()
    .from(t)
    .fetch();
 

Instances can be created using Name.fields(String...) and overloads.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
<R extends Record> CommonTableExpression<R>	as(Select<R> select)	Specify a subselect to refer to by the DerivedColumnList to form a common table expression.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

as

@Support({AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<R extends Record> CommonTableExpression<R> as(Select<R> select)

Specify a subselect to refer to by the DerivedColumnList to form a common table expression.