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?
A)SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B)SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C)SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';
D)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E)None of the above.

Question

Quizplus · Accepted Answer

The SQL keyword LIKE is used to search for a pattern within a column. The pattern in this case is 'S%', which means the column Name must start with the character "S" and can be followed by any number of characters. This will return all employees whose name begins with "S". Therefore, option D is the correct choice.

Given a Table with the Structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the Following