The ANY and ALL operators returns true if any of the subquery values match the condition and ANY and ALL operators used in where and having clause SQL statement