Which Sql statement would you use to select all employees who are Software Engg,B.A. Or Programmer?

 Posted by vishalneeraj-24503 on 7/2/2014 | Category: Sql Server Interview questions | Views: 2452 | Points: 40
Select from following answers:
  1. select emp_id,employee_name from employee_master where designation = 'Software Engg' and 'B.A.' and 'Programmer';
  2. select emp_id,employee_name from employee_master where designation = 'Software Engg' and designation = 'B.A.' and designation = 'Programmer';
  3. select emp_id,employee_name from employee_master where designation In ('Software Engg','B.A.','Programmer');
  4. None of these
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response