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


FROM      Student_Table

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 ...

Get Aster Data SQL and MapReduce now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.