Module org.jooq
Package org.jooq

Interface DerivedColumnList20

  • All Superinterfaces:
    QueryPart, Serializable

    public interface DerivedColumnList20
    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

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      <R extends Record20<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?>>
      @NotNull CommonTableExpression<R>
      as​(Select<R> select)
      Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
      <R extends Record20<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?>>
      @NotNull CommonTableExpression<R>
      asMaterialized​(Select<R> select)
      Specify a materialized subselect to refer to by the DerivedColumnList to form a common table expression.
      <R extends Record20<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?>>
      @NotNull CommonTableExpression<R>
      asNotMaterialized​(Select<R> select)
      Specify a non-materialized subselect to refer to by the DerivedColumnList to form a common table expression.