Title: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... Post by: skypeaches on Feb 9, 2019 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?
• SELECT * FROM EMPLOYEE WHERE Name IN ['S']; • SELECT EmpNo FROM EMPLOYEE WHERE Name LIKE 'S'; • SELECT * FROM EMPLOYEE WHERE Name LIKE 'S*'; • SELECT * FROM EMPLOYEE WHERE Name LIKE 'S%'; Title: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... Post by: a_sabu2 on Feb 9, 2019 Content hidden
|