Javatpoint Logo
Javatpoint Logo

SQL Server BETWEEN Condition (Operator)

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.

Output:

SQL Between condition 1

Or

Output:

SQL Between condition 2

BETWEEN operator with NOT Operator

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

Output:

SQL Between condition 3

Or

Output:

SQL Between condition 4
Next TopicIS NULL Operator




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


B.Tech / MCA