Which Alternate Sql statement would you use to select all employees whose employee Id ranging 100 to 200 instead of Between operator?

Answer:

We will use Comparison Operator like Less than(<) and Greater than (>) operator instead of Between Logical operator as

select emp_id,employee_name 

from employee_master 

where emp_id >= 100 and emp_id <= 200;

Above query will give us the same result as Between gives.