Question: Consider the following queries: 1 . SELECT * FROM customer WHERE support _ rep _ id IN ( SELECT employee _ id FROM employee WHERE
Consider the following queries:
SELECT FROM customer
WHERE supportrepid IN
SELECT employeeid FROM employee
WHERE firstname 'Steve';
SELECT customer. FROM customer
INNER JOIN employee
ON customer.supportrepid employee.employeeid
WHERE employee.firstname 'Steve';
Which of these would be the most efficient?
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
Study Help