BETWEEN()

The SQL BETWEEN Condition is used to retrieve values within a range in a SELECT, INSERT, UPDATE, or DELETE statement.

The basic syntax is as follows.:

SELECT * FROM tables WHERE column BETWEEN value1 AND value2;

Employee
Emp_id	Name	Surname	Salary	Dept_id
1	Rajesh	Khanna	45000	2
2	Sneha	Gupta	55000	4
3	Sandeep	Nehte	95000	1
4	Kirti	Patil	25000	3
5	Nilesh	Jadhav	45000	3
6	Dipesh	Das	35000	5
7	Kailash	Rane	62000	1
8	Kavita	Deshpande	48000	3
9	Sanjay	Datt	50000	2
10	Shruti	Hasan	78000	1
11	Sandeep	Deshmukh	52000	3

SQL Syntax:

SELECT * FROM Employee WHERE Dept_id BETWEEN 30000 AND 60000;

After Execution:

Employee
Emp_id	Name	Surname	Salary	Dept_id
1	Rajesh	Khanna	45000	2
2	Sneha	Gupta	55000	4
5	Nilesh	Jadhav	45000	3
6	Dipesh	Das	35000	5
8	Kavita	Deshpande	48000	3
9	Sanjay	Datt	50000	2
11	Sandeep	Deshmukh	52000	3