Between operator in sql

By: Prof. Dr. Fazal Rehman | Last updated: March 3, 2022

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.