SQL BETWEEN Operator

The BETWEEN operator is used to select values within a particular range.

Syntax:

SELECT *
FROM table_name
WHERE column_some_name BETWEEN value_1 AND value_2

As you see, we have like this "Candidate" table.

Example:

The following SQL syntax selects all candidate with a CandidateId between '5' and '12'

select * from CANDIDATE where CandidateId between '5' and '12'

Output: