What is the use of BETWEEN Function in SQL?

The SQL BETWEEN condition allows you to easily test if an expression is within a range of values (inclusive). The values can be text, date, or numbers. It can be used in a SELECT, INSERT, UPDATE, or DELETE statement. The SQL BETWEEN Condition will return the records where expression is within the range of value1 and value2.


SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;

  • Using BETWEEN with Numeric Values:

List all the Employee Fname, Lname who is having salary between 30000 and 45000.

SELECT Fname, Lname FROM Employee WHERE Salary BETWEEN 30000 AND 45000;

  • Using BETWEEN with Date Values:

Find all the Employee having Date of Birth Between 01-01-1985 and 12-12-1990.

SELECT Fname, Lname FROM Employee where DOB BETWEEN '1985-01-01' AND '1990-12-30';