× Didn't find what you were looking for? Ask a question
  
  
  
Top Posters
Since Sunday
36
35
33
31
30
30
30
30
28
28
28
27
New Topic  
wrote...
Posts: 302
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 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
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 23 times
2 Replies
Education is the most powerful weapon which you can use to change the world.
Related Topics
Replies
wrote...
2 months ago
SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
wrote...
2 months 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
  347 People Browsing
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 152

Related Images
 4890
 113
 88