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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
