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 EMPLOYEE
WHERE Name LIKE 'S*';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
C
Business
You might also like to view...
A fund's reinvestment plan allows investors to
A) make periodic deposits to the fund from their checking accounts. B) make regular withdrawals from the fund. C) reinvest all dividends and/or capital gains into the fund's shares. D) reinvest profits from one fund into shares of another fund.
Business
The Dr. Jekyll and Mr. (or Ms.) Hyde game refers to the difference between how a person treats
a. different subordinates. b. family members versus employees. c. subordinates versus other work associates. d. subordinates in private versus in publi c.
Business