1. What is the difference between IN and ANY comparison subqueries?
- '= ANY' is semantically equivalent to 'IN'.
- ANY only works on numeric data.
- IN is always faster than ANY.
- ANY requires all elements to match.
Hint: 'val = ANY (SELECT...)' is identical to 'val IN (SELECT...)'. The ANY keyword provides flexibility when combined with other operators like '<' or '>'.