The ALL keyword is used in these contexts:
ALL, DISTINCT, DISTINCTROW, TOP Predicates
SQL Subqueries
UNION Operation