Are SQL ANY and SOME keywords synonyms in all SQL dialects? Are SQL ANY and SOME keywords synonyms in all SQL dialects? sql sql

Are SQL ANY and SOME keywords synonyms in all SQL dialects?


Few lines after what you're quoting, the SQL92 standard also specifies the semantics for <some>, namely:

c) If the implied <comparison predicate> is true for at leastone row RT in T, then "R <comp op> <some> T" is true.d) If T is empty or if the implied <comparison predicate> isfalse for every row RT in T, then "R <comp op> <some> T" isfalse.e) If "R <comp op> <quantifier> T" is neither true nor false,then it is unknown.

These rules apply for the <some> token, independent on whether it is the SOME or ANY alternative, so yes, they are synonyms according to the standard