The Between operator in SQL can be used to select values within a given range.
Syntax
SELECT column_names
FROM table_name
WHERE column_name BETWEEN first_Value AND second_Value;
Use of NOT Between operator in SQL Query
SELECT * FROM students
WHERE fee NOT BETWEEN 1000 AND 2000;
Use of Between operator in SQL Query
SELECT * FROM students
WHERE fee BETWEEN 1000 AND 2000;
Excercise: Download the Database of Between operator in SQL and practice it on your XAMPP phpMyAdmin.