Which Sql statement would you use to select all employees whose first name starts with 'F'?

 Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 1625 | Points: 40
Select from following answers:
  1. select emp_id,employee_name from employee_master where first_name like 'F';
  2. select emp_id,employee_name from employee_master where first_name in 'F;
  3. select emp_id,employee_name from employee_master where first_name like 'F%';
  4. select emp_id,employee_name from employee_master where first_name like '%F';
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response