Between SQL Tutorial

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