Top Posters
Since Sunday
25
24
23
22
22
22
22
21
21
21
21
20
New Topic  
wrote...
Posts: 262
Rep: 0 0
2 months ago
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%';
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 14 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 191
2 months ago
Sign in or Sign up in seconds to unlock everything.
SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*';
Related Topics
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  337 People Browsing
 138 Signed Up Today
Related Images
 103
 69
 59