Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: skypeaches on Feb 9, 2019



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