Ask a Question
  
  
  
Top Posters
Since Sunday
26
15
11
10
9
9
9
8
8
7
7
7
New Topic  
wrote...
Posts: 303
Rep: 0 0
A week 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 standard SQL?

• SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];

• SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';

• SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';

• SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 6 times
2 Replies
Education is the most powerful weapon which you can use to change the world.
Related Topics
Replies
wrote...
A week ago
SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
wrote...
A week ago
Good timing, thanks!
Education is the most powerful weapon which you can use to change the world.
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
  62 People Browsing
 122 Signed Up Today
Related Images
 892
 31
 14