Module org.jooq
Package org.jooq

Interface WithAsStep9


  • public interface WithAsStep9
    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 Record9<?,​?,​?,​?,​?,​?,​?,​?,​?>> select)
      Associate a subselect with a common table expression's table and column names.
      @NotNull WithStep asMaterialized​(Select<? extends Record9<?,​?,​?,​?,​?,​?,​?,​?,​?>> select)
      Associate a materialized subselect with a common table expression's table and column names.
      @NotNull WithStep asNotMaterialized​(Select<? extends Record9<?,​?,​?,​?,​?,​?,​?,​?,​?>> select)
      Associate a non-materialized subselect with a common table expression's table and column names.