DML-select-Between:

nBetween used to select the particular range of values

The values can be numbers, text, or dates.

Syntax:

SELECT column_name FROM table_name WHERE column_name
BETWEEN value1 AND value2

Query:

SELECT * from Emptbl1 where EMPname between ‘Batista’ and ‘William’