-   The result is NULL if the comparison does not return true for any row,
+   The result is NULL if no comparison with a subquery row returns true,
    and it returns NULL for at least one row.

-The result of ANY is “true” if the comparison returns true for any subquery row. The result is “false” if the comparison returns false for every subquery row (including the case where the subquery returns no rows). The result is NULL if the comparison does not return true for any row, and it returns NULL for at least one row.

 

Similary to:

>The result of ALL is "false" even if *at least one*  row yield false

 

+The result of ANY is "true" if at least one row yields true.

The result of ANY is "false" if all rows yield false

The result of ANY is NULL if no one row yelds true and at least one row yields NULL

When subquery return no rows the result of ANY is "false"

 

sentences are short, easy to spot when and how result is changed

 

 

 

12.10.2018, 00:20, "David G. Johnston" <david.g.johnston@gmail.com>: