Question: Given a table with the structure: EMPLOYEE ( Emp _ No , Emp _ Name, Emp _ Salary, Emp _ HireDate ) which of the

Given a table with the structure:
EMPLOYEE (Emp_No, Emp_Name, Emp_Salary, Emp_HireDate)
which of the following would list the Emp_No for only employees whose name includes the letters "da" or "ad" in consecutive order, using standard SQL within MySQL?
SELECT Emp_No
FROM EMPLOYEE
WHERE Emp_Name LIKE "%[a,d][d,a]%"
SELECT Emp_No
FROM EMPLOYEE
WHERE EIR_Name LIKE "%da%";
SELECT Emp_No
FROM EMPLOYEE
WHERE Emp_Name LIKE "%da%" OR LIKE "%ad%";
SELECT Emp_No
FROM EMPLOYEE
WHERE Emp_Name LIKE "%da%" OR Emp_Name LIKE "%ad%";
SELECT Emp_No
FROM EMPLOYEE
WHERE Emp_Name BETWEEN "a" and "d";
 Given a table with the structure: EMPLOYEE (Emp_No, Emp_Name, Emp_Salary, Emp_HireDate)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!