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

 Posted by vishalneeraj-24503 on 7/2/2014 | Category: Sql Server Interview questions | Views: 406 | Points: 40
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.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response