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

-Anonymous

BETWEEN is Inclusive

SELECT   *

FROM      Student_Table

WHERE   Grade_Pt  BETWEEN  2.0 AND 4.0 ;

image

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

image

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.