Microsoft
70-433 · Question #127
You have a table named Employees. You want to identify the supervisor to which each employee reports. You write the following query. SELECT e.EmloyeeName AS [EmployeeName], s.EmployeeName AS…
The correct answer is A. LEFT JOIN Employees s. See the full explanation below for the reasoning.
Question
You have a table named Employees. You want to identify the supervisor to which each employee reports. You write the following query. SELECT e.EmloyeeName AS [EmployeeName], s.EmployeeName AS [SuperVisorName] FROM Employees e You need to ensure that the query returns a list of all employees and their respective supervisor. Which join clause should you use to complete the query?
Options
- ALEFT JOIN Employees s
- BRIGHT JOIN Employees s
- CINNER JOIN Employees s
- DLEFT JOIN Employees s
How the community answered
(15 responses)- A80% (12)
- B13% (2)
- C7% (1)
Community Discussion
No community discussion yet for this question.