ANY / SOME operators

Zandu balm cold

Sustiva half life
The ANY and SOME operators, which are synonyms, perform a Boolean test returning true if even one record in the result set matches the Boolean condition. ANY/SOME is semantically equivalent to IN and EXISTS, but much less widespread.  To ensure easy maintenance of your code, use IN or EXISTS rather than ANY/SOME wherever possible.

Cefaclor 250 mg bula

Nexium withdrawal symptoms
A bit more explanation,  ANY/SOME operators return TRUE when at least one record matches and return FALSE when none match or when there’s an empty result set.  If any of the values are NULL, then the operation value will be NULL, not TRUE.

Real viagra cheap online
404 Not Found
404 Not Found
Is aciphex a generic drug
ANY/SOME can be used for filtering checks similar to an IN or EXISTS subquery. In this example, we will get any employee records that also exist in the employees_archive table with a city of Anchorage.

FROM employees
WHERE job_lvl = ANY(SELECT job_lvl FROM employees_archive
                    WHERE city = ‘Anchorage’)



New anti wrinkle cream in boots 2011

WHERE expression comparison {ANY | SOME} ( subquery )


WHERE expression

Tests a single value, such as a column, against every value until a match is found for ANY and SOME.  One or more rows must match the expression, for ANY and SOME, to return a Boolean TRUE value.


Compares the expression to the subquery.  The comparison must be a standard comparison operator like =, <>, !=, >, >=, <, or <=.

Related Entries








Google Author

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • email
  • LinkedIn
  • HackerNews
  • Posterous
  • Reddit
  • Technorati
  • Tumblr

Speak Your Mind