Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There are of examples in other forums, suggesting the ANY function is similar to IN and EXISTS and can be used in similar circumstances. ANY returns true on the first matched row, ALL returns false on the first non-match. Here is an example:

FROM "Tbl1"
WHERE "Col1" = ANY(SELECT 'str' FROM `Tbl2`)

The direct MySQL connector does not seem to allow the syntax, although MySQL does.

The syntax > ALL(SELECT Col1... is used as a synonym for > (SELECT MAX(Col1 ... with reference to numeric columns.

(if this answers your question, please accept the answer by clicking the check (image description) to the left)