Module org.jooq
Package org.jooq

Interface QuantifiedSelect<R extends Record>

  • All Superinterfaces:
    QueryPart, Serializable

    public interface QuantifiedSelect<R extends Record>
    extends QueryPart
    A quantified select for use in quantified comparison predicates.

    Example:

     // Assuming import static org.jooq.impl.DSL.*;
    
     using(configuration)
        .select()
        .from(CUSTOMER)
        .where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).eq(any(
            select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
        )))
        .fetch();
     

    Instances can be created using DSL.any(Select) and DSL.all(Select).

    Author:
    Lukas Eder