Chapter 10 – The Fundamental SQL Commands That Work on Aster
“The most important thing a father can do for his children is to love their mother.”
BETWEEN is Inclusive
WHERE Grade_Pt BETWEEN 2.0 AND 4.0 ;
This is a BETWEEN. What this allows you to do is see if a column falls in a range. It is inclusive, meaning that in our example, we will be getting the rows that also have a 2.0 and 4.0 in their column!
BETWEEN Works for Character Data
The BETWEEN isn’t just used with numbers. You can look to ...