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 "S" using Microsoft Access?
A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C) SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E) None of the above.

Answer 1

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate)
SQL to find all employees whose name begins with the letter "S" using Microsoft Access is
SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';

D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';