August 25th, 2008
AND, OR, and NOT, Part 3 of 3
Posted by
admin in
D. WHERE Clause
Sometimes you can rewrite a condition, so that its meaning is easier to grasp.These two statements are equivalent:
Which one was easier for you to understand?
We are used to saying, “Less than 10,000 AND more than 100,000.” But if we write:
This will never return data, because if the price is less than 10,000, then the price can not be greater than 100,000. Rewrite the statement:
Comments Off
