Consider the following exhibit:
SQL> DESC Employee
SQL> SELECT * FROM Employee;
14 rows selected
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.
14
B.
1
C.
13
D.
0