Question

Raj is a database programmer, He has to write the query from EMPLOYEE table to search for the employee whose name begins from letter "R", for this he has written the query as: SELECT * FROM EMPLOYEE WHERE NAME=‟R%‟; But the query is not producing the correct output, help Raj and correct the query so that he gets the desired output.​

Answer 1

Answer:

SELECT * FROM EMPLOYEE WHERE NAME LIKES 'R%';