Question: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?

a.

SELECT *

FROM EMPLOYEE

WHERE Name LIKE 'S*';

b.

SELECT *

FROM EMPLOYEE

WHERE Name IN ['S'];

c.

SELECT EmpNo

FROM EMPLOYEE

WHERE Name LIKE 'S';

d.

SELECT *

FROM EMPLOYEE

WHERE Name LIKE 'S%';

e.

SELECT

FROM EMPLOYEE

WHERE Name LIKE 'S%';

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!