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 EmpNo EmpName, EmpSalary, EmpHireDate
which of the following would list the EmpNo for only employees whose name includes the letters da or ad in consecutive order, using standard SQL within MySQL
SELECT EmpNo
FROM EMPLOYEE
WHERE EmpName LIKE adda
SELECT EmpNo
FROM EMPLOYEE
WHERE EIRName LIKE da;
SELECT EmpNo
FROM EMPLOYEE
WHERE EmpName LIKE da OR LIKE ad;
SELECT EmpNo
FROM EMPLOYEE
WHERE EmpName LIKE da OR EmpName LIKE ad;
SELECT EmpNo
FROM EMPLOYEE
WHERE EmpName BETWEEN and ;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
