SQL – appointing multiple where clauses to a single subquery Is it possible to appoint multiple where clauses to a single subquery on an Oracle Database?