Contents Index Subqueries in the HAVING clause Subquery comparison test

ASA SQL User's Guide
  Using Subqueries
    Subqueries in the HAVING clause

Subquery tests


The chapter Queries: Selecting Data from a Table describes simple search conditions you can use in the HAVING clause. Since a subquery is just an expression that appears in the WHERE or HAVING clauses, the search conditions on subqueries may look familiar.

They include:


Contents Index Subqueries in the HAVING clause Subquery comparison test