Technology Exchange
免费咨询热线
400-090-9964
【2020年8月】Oracle OCP 071考试新题(-13题)CUUG内部题库
Choose the best answer.
Examine this statement which returns the name of each employee and their manager:
SELECT e.last_name AS emp, m.1ast_name AS mgr
FROM employees e
JOIN managers m
ON e.manager_id = m.employee_id
ORDER BY emp;
You want to extend the query to include employees with no manager. What must you add before JOIN to do this?
A) LEFT OUTER
B) RIGHT OUTER
C) CROSS
D) FULL OUTER
2020年8月份Oracle OCP 071考试新题-13题)CUUG内部题库,钉钉群(35277291)Oracle金牌名师亲自题库解析