Answer to Question #256270 in Databases | SQL | Oracle | MS Access for Rajdeep

Question

Display the managerial hierarchy from Ruth Ellerbrock (person type – EM) up to CEO Ken Sanchez. Hint: use

[uspGetEmployeeManagers] (Schema(s) involved: [Person], [HumanResources])

DATABASE- AdverntureWorks2017

Answer 1

USE AdverntureWorks2017
SELECT Person, HumanResources 
FROM uspGetEmployeeManagers;