View the Exhibit and examine the data in the EMPLOYEES table:
You want to display all the employee names and their corresponding manager names.
Evaluate the following query:
SQL> SELECT e.employee_name “EMP NAME”, m.employee_name “MGR NAME”
FROM employees e ______________ employees m
ON e.manager_id = m.employee_id;
Which JOIN option can be used in the blank in the above query to get the required output?
Exhibit:
A.
only inner JOIN
B.
only FULL OUTER JOIN
C.
only LEFT OUTER JOIN
D.
only RIGHT OUTER JOIN
Why right outer join will not give the same result.
RIGHT JOIN produces also employees who are not managers.
And misses out on employees without managers.
it should be A since it gives only matched values
Every as soon as in a even though we opt for blogs that we read. Listed beneath are the latest web sites that we pick
Here is a good Weblog You might Come across Fascinating that we Encourage You
we like to honor quite a few other online websites around the web, even though they arent linked to us, by linking to them. Beneath are some webpages worth checking out
we came across a cool website that you may love. Take a search in the event you want
the time to read or go to the content material or internet sites we’ve linked to beneath the
The data talked about inside the post are some of the top offered
although web-sites we backlink to below are considerably not connected to ours, we really feel they may be truly really worth a go by means of, so possess a look
usually posts some pretty interesting stuff like this. If youre new to this site