Between Operator

Specifies the range and selects data within it.


Select * From STUDENT_DATBASE
Where Marks BETWEEN 20 AND 40;

NOT keyword can also be used to exclude the range




Select * From STUDENT_DATBASE
Where Marks NOT BETWEEN 20 AND 40;