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