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