SQL Server BETWEEN Operator

SQL Server BETWEEN Operator

The SQL BETWEEN Condition will return the records where expression is within the range of value1 and value2.

Syntax

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

Examples

SELECT Fname, Lname
FROM Employees
WHERE Salary
BETWEEN 20000 AND 35000

2020-03-29