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

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

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response