8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for ALL, ANY and SOME Comparison Conditions in SQL

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
one question
is not valid case in case of characters
Let us know

Tim... said...


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

Vijay said...

Good Explanation..!

Sangeetha said...

Very well explained. Thanks for the post.

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.