Using OR, AND, ANY, and ALL with SQL queries
Not what you're looking for?
The OR and AND operators are used in compound conditions. Is there any relationship between these operators and the ALL and ANY operators? Outside references are required.
Purchase this Solution
Solution Summary
This solution shows how to use OR, AND, ANY, and ALL in SQL queries. It also explains how they work.
Solution Preview
The MySql operators OR and AND can be used in conditions in a query. For example:
SELECT * FROM mytable WHERE id > 100 AND age < 65;
This statement selects all the items from the table where the id is
greater than 100 AND the age is less than 65. Both conditions must be
met. Likewise, the following query uses the OR operator:
SELECT * FROM mytable ...
Purchase this Solution
Free BrainMass Quizzes
Javscript Basics
Quiz on basics of javascript programming language.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.