130.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?
A.only inner JOIN
B.only FULL OUTER JOIN
C.only LEFT OUTER JOIN
D.only RIGHT OUTER JOIN
答案:C
解析:题目说要显示所有的employee names和他们对应的manager names,这里7902和77698没有employee_id
因此,这里只能使用left join,这里排除full,join是由于结果会多出来多余的数据
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?
A.only inner JOIN
B.only FULL OUTER JOIN
C.only LEFT OUTER JOIN
D.only RIGHT OUTER JOIN
答案:C
解析:题目说要显示所有的employee names和他们对应的manager names,这里7902和77698没有employee_id
因此,这里只能使用left join,这里排除full,join是由于结果会多出来多余的数据