Select from following answers:- select emp_id,employee_name from employee_master where designation = 'Software Engg' and 'B.A.' and 'Programmer';
- select emp_id,employee_name from employee_master where designation = 'Software Engg' and designation = 'B.A.' and designation = 'Programmer';
- select emp_id,employee_name from employee_master where designation In ('Software Engg','B.A.','Programmer');

- None of these
- All Above
select emp_id,employee_name from employee_master where designation In ('Software Engg','B.A.','Programmer');
IN operator is better way to query to get above result-set.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator