MS Sql Server Tutorials | Examples | Interview Questions Tutorial

MS SQL Server BETWEEN Operator

❮ Previous Next ❯

Between Operator is used to fetch data between specified range using SELECT, UPDATE, INSERT or DELETE statement.
Syntax:

expression BETWEEN value1 AND Value2

Example:

SELECT * FROM [University].[dbo].[Student] WHERE Age BETWEEN 18 AND 20;

SELECT * FROM [University].[dbo].[Student] WHERE Age>=18 AND Age<= 20;

Example:

SELECT * FROM [University].[dbo].[Student] WHERE Age NOT BETWEEN 18 AND 19;

SELECT * FROM [University].[dbo].[Student] WHERE Age<18 AND Age> 20;

❮ Previous Next ❯