O'Reilly logo

Aster Data Database Administration by Todd Wilson, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 21 – 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required