34,333
edits
Changes
→Filtering Using the AND Operator
</pre>
== Filtering Data Using the AND Operator ==
Another operator used to combine filtering criteria when using the ''WHERE'' clause is the AND operator. The ''AND'' operator selects rows based on the requirement that meet multiple requirements (as opposed to the "either or" approach of the ''OR'' operator). Suppose, for example, that we need to find a "Microsoft 10-20 Keyboard" that costs less than $30. TO do so we would construct a SELECT statement as follows:
