Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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";
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Using Language That Works

Answered: 1 week ago

Question

4. Are my sources relevant?

Answered: 1 week ago