Which Sql statement would you use to select all employees whose employee Id ranging 100 to 200;

 Posted by vishalneeraj-24503 on 7/2/2014 | Category: Sql Server Interview questions | Views: 873 | Points: 40
Select from following answers:
  1. select emp_id,employee_name from employee_master where emp_id = 100 and 200;
  2. select emp_id,employee_name from employee_master where emp_id between 100 and 200;
  3. select emp_id,employee_name from employee_master where emp_id = 100 and emp_id = 200;
  4. All of the above.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response