Ask a Question
  
  
  
Top Posters
Since Sunday
208
110
25
24
22
22
21
21
21
20
20
19
New Topic  
wrote...
Posts: 267
Rep: 0 0
6 days 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 Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 11 times
1 Reply
Replies
Answer verified by a subject expert
wrote...
Posts: 193
6 days ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*';
New Topic      
Share This Topic
Similar topics that might interest you...
Business   2 years ago   boyob89   MartyJay   3 Replies   54 Views
Business   6 months ago   almostutterly   2 Replies   16 Views
Accounting   A year ago   harra   migrod   1 Reply   27 Views
Accounting   A year ago   harra   2 Replies   29 Views
4 More
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
  64 People Browsing
 116 Signed Up Today
Related Images
 874
 7467
 61
Your Opinion
What's your favorite coffee beverage?
Votes: 52