Module org.jooq
Package org.jooq

Interface WithAsStep11


  • public interface WithAsStep11
    This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.

    Example:

     DSL.with("table", "col1", "col2")
        .as(
            select(one(), two())
        )
        .select()
        .from("table")
     
    Author:
    Lukas Eder
    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      @NotNull WithStep as​(Select<? extends Record11<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?>> select)
      Associate a subselect with a common table expression's table and column names.
      @NotNull WithStep asMaterialized​(Select<? extends Record11<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?>> select)
      Associate a materialized subselect with a common table expression's table and column names.
      @NotNull WithStep asNotMaterialized​(Select<? extends Record11<?,​?,​?,​?,​?,​?,​?,​?,​?,​?,​?>> select)
      Associate a non-materialized subselect with a common table expression's table and column names.