What is TRUE regarding ANY clause?

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?