Consider the table engineer given below:
Query:
SELECT e1.engid FROM engineer e1 INNER JOIN engineer e2 ON e1.managerid=e2.managerid
WHERE e1.engineername LIKE '%a%' AND e1.engid<>e2.engid;
What will be the managerID of the engineer who is extracted from the execution of the above Query?

Question

Consider the table engineer given below:

A table of information

Description automatically generated with medium confidence

Query:

SELECT e1.engid FROM engineer e1 INNER JOIN engineer e2 ON e1.managerid=e2.managerid
WHERE e1.engineername LIKE '%a%' AND e1.engid<>e2.engid;

What will be the managerID of the engineer who is extracted from the execution of the above Query?

anonymous · Accepted Answer

Correct Solution - a

Consider the table engineer given below:Query:SELECT e1.engid FROM engineer e1 INNER JOIN engineer e2 ON e1.managerid=e2.manageridWHERE e1.engineername LIKE '%a%' AND e1.engid<>e2.engid;What will be the managerID of the engineer who is extracted from the execution of the above Query?