What is an alternate way of IN operator to query for selecting all employees who are Software Engg,B.A. Or Programmer?

 Posted by vishalneeraj-24503 on 7/2/2014 | Category: Sql Server Interview questions | Views: 528 | Points: 40
Answer:

OR operator is used to achieve the same thing as IN operator does.
Select emp_id,employee_name 

from employee_master
where designation = 'Software Engg'
OR designation = 'B.A.'
OR designation = 'Programmer';


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response