ASA SQL User's Guide
  Using Subqueries

Quantified comparison tests with ANY and ALL

The quantified comparison test has two categories, the ALL test and the ANY test:

The ANY test
The ALL test