The SQL ANY and ALL Operators
The ANY and ALL operators allow you to perform a comparison between a single column value and a range of other values.
The SQL ANY Operator
Note: The operator must be a standard comparison operator (=, <>, !=, >, >=, <, or <=).
Demo Database
Below is a selection from the "Products" table in the Northwind sample database:
SQL ANY Examples
The following SQL statement lists the ProductName if it finds ANY records in the OrderDetails table has Quantity equal to 10 (this will return TRUE because the Quantity column has some values of 10):
SQL ALL Examples
The following SQL statement lists the ProductName if ALL the records in the OrderDetails table has Quantity equal to 10. This will of course return FALSE because the Quantity column has many different values (not only the value of 10):
Popular Posts:
- 1. who said anything about safe? 'course he isn't safe. but he's good. he's the king, i tell you..."
- 2. what does coastal truk driving school charge for their course?
- 3. what was one of the main reasons why islam spread into europe? course hero
- 4. what does the post bankruptcy course consist of
- 5. how to program finch robot to go through obstacle course
- 6. where is turf paradise race course
- 7. where do i take the 45 hours dcf course in west palm beach florida
- 8. how to become a mentor in a coursera course
- 9. how long is the electrical course at lincoln tech
- 10. what technology traces the course of a golf ball in the air