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

Comments

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
=All(List)
is not valid case in case of characters
Let us know

Tim... said...

Hi.

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.

Cheers

Tim...

Jannie said...

Thanks for this excellent explanation

DO NOT ask technical questions here, that's what my forum is for!

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.
Name
Comment
(max 400 chars - plain text)