× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
o
5
4
m
4
b
4
x
4
a
4
l
4
t
4
S
4
m
3
s
3
New Topic  
killak killak
wrote...
Posts: 331
Rep: 0 0
5 years 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%';
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 65 times
2 Replies
Education is the most powerful weapon which you can use to change the world.

Related Topics

Replies
wrote...
5 years ago
SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
killak Author
wrote...
5 years 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
  914 People Browsing
 114 Signed Up Today
Related Images
  
 1184
  
 186
  
 131
Your Opinion