T-SQL Tutorial

SQL Between


Between Syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value_a AND value_b

Employee table:

EMPLOYEE_IDNAMEDEP_ID
1John33
2Samantha34
3Bill35
4James36
5Sandra37

Between Example:

SELECT * FROM employee
WHERE dep_id BETWEEN 34 AND 36;

Between Result:

2Samantha34
3Bill35
4James36