Comments for ALL, ANY and SOME Comparison Conditions in SQL
|ALL, ANY and SOME Comparison Conditions in SQL - A quick look at some comparison conditions you may not be used to seeing in SQL against an Oracle database.|
shawn said...Excellent article.
Excellent in depth explanation.
Really hard to find, as rarely as these operators are used:-)
shakib said...Thanks for posting, this post solve my problems.
Prasad said...Excellent notes
is not valid case in case of characters
Let us know
Think about it. How is it possible for a column to be valid to multiple values? Using "= ALL" does not make sense because it would always be false unless all values in the ALL clause were the same.
Jannie said...Thanks for this excellent explanation