Between operator in sql

By: Prof. Fazal Rehman Shamil

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;

Between operator in sql

Use of Between operator in SQL Query

SELECT * FROM students
WHERE fee BETWEEN 1000 AND 2000;

sql Between operator

Excercise: Download the Database of Between operator in SQL and practice it on your XAMPP phpMyAdmin.

Prof. Fazal Rehman Shamil