Select from following answers:- select emp_id, employee_name from employee_master where last_name like 'F';
- select emp_id, employee_name from employee_master where last_name like 'F%';
- select emp_id, employee_name from employee_master where last_name in 'F';
- select emp_id, employee_name from employee_master where last_name like '%F';
- All Above
select emp_id, employee_name from employee_master where last_name like '%F';
Above query is the correct way search last name ending with F.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator