Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


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
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

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!

Add your comments here.
(max 400 chars - plain text)