The SOME, ANY and ALL are logical operators that compare against a scalar value. This article is a simple overview of how they work.

Sample Data

[crayon-5b52fa8d3b0d7294896768/]

SOME and ANY:

[crayon-5b52fa8d3b0e3615512642/] Results: [crayon-5b52fa8d3b0e8984050176/] If the 50000 in the WHERE clause is...

Read More