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 (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.