Select the suitable option for retrieving all the employees whose name ends with "kumar"?
Answer options
A
SELECT * FROM employee WHERE empname LIKE '%kumar';
B
SELECT * FROM employee WHERE empname LIKE 'kumar%';
C
SELECT * FROM employee WHERE empname = 'kumar';
D
SELECT * FROM employee WHERE empname LIKE '%kumar%';
Correct answer: SELECT * FROM employee WHERE empname LIKE '%kumar';
Explanation
The % wildcard at the start matches any prefix; '%kumar' matches names ending with 'kumar'.