How many records will the above query retrieve?

Consider the following exhibit:
SQL> DESC Employee

The Employee table has 14 rows. You want to retrieve the names of all employees and their
managers. Therefore, you issued the following query:
SELECT e.ename, m.ename
FROM employee e INNER JOIN employee m
ON e.manager_id = m.employee_id;

How many records will the above query retrieve?

Consider the following exhibit:
SQL> DESC Employee

The Employee table has 14 rows. You want to retrieve the names of all employees and their
managers. Therefore, you issued the following query:
SELECT e.ename, m.ename
FROM employee e INNER JOIN employee m
ON e.manager_id = m.employee_id;

How many records will the above query retrieve?

A.
1

B.
0

C.
13

D.
14



Leave a Reply 0

Your email address will not be published. Required fields are marked *