SQL Server BETWEEN Condition (Operator)

Last Updated : 31 Jul 2026

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

Syntax:

Parameter Explanation

expression: It specifies a column or a calculation.

value1 and value2: These values specify inclusive range that is used by expression for comparison.

BETWEEN operator with Numeric Value

Retrieve all employees from table "Employees" where id is between 7 and 13.

SELECT *
FROM [javatpoint].[dbo].[Employees]
WHERE id BETWEEN 7 AND 13; 

Output:

SELECT *
FROM [javatpoint].[dbo].[Employees]
WHERE id >= 7
AND id <= 13; 

Output:

BETWEEN operator with NOT Operator

Retrieve all employees from table "Employees", where it satisfies the following BETWEEN NOT condition.

SELECT *
FROM [javatpoint].[dbo].[Employees]
WHERE id NOT BETWEEN 7 AND 11; 

Output:

SELECT *
FROM [javatpoint].[dbo].[Employees]
WHERE id < 7
OR id > 11;

Output:

Next TopicIS NULL Operator

← prev next →

We deliver comprehensive tutorials, interview question-answers, MCQs, study materials on leading programming languages and web technologies like Data Science, MEAN/MERN full stack development, Python, Java, C++, C, HTML, React, Angular, PHP and much more to support your learning and career growth.