Write a SQL query to find the names of employees that begin with S

Question

Hi!!

Can someone tell me how to write the query for the above statement?

Answer 1

To display the name of the employees that begin with ‘S’, type in the below command:

SELECT * FROM Table_name WHERE EmpName like 'S%'

Answer 2

Select ename
From emp
Where ename like"s%";