Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 1 2 Not yet answered Marked out of 2 . 0 0 which of the following queries used to display the names of the
Question
Not yet answered Marked out of
which of the following queries used to display the names of the employees and their managers.
a SELECT eemployeeid emp, mlastname mgr FROM employees emp JOIN employees mgr ON emanagerid memployeeid;
b SELECT eemployeeid emp, mlastname mgr FROM employees m JOIN employees e ON emanagerid memployeeid;
c SELECT efirstname emp, mlastname mgr FROM employees m JOIN employees e ON eemployeeid memployeeid;
d None of the mentioned
e SELECT efirstname emp, mlastname mgr FROM employees e JOIN employees ON emanagerid eemployeeid;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started