Module org.jooq
Package org.jooq

Interface DerivedColumnList14

All Superinterfaces:
QueryPart, Serializable

public interface DerivedColumnList14 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 Record14<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    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>
    Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record14<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.

    Methods inherited from interface org.jooq.QueryPart

    equals, hashCode, toString