Use HR database (Sample tables and data are in DatabaseHR.pdffile). Write a query to show employee id, last name, first name ofall the employees, their managers, and the managers of theirmanagers.
You need to include the following columns in your result: EMPLOYEE_ID EmployeeLastName FirstLevelManagerFirstName SecondLevelManagerID SecondLevelManagerLastName EmployeeFirstName FirstLevelManagerID FirstLevelManagerLastName SecondLevelManagerFirstName ThirdLevelManagerID
Use HR database (Sample tables and data are in DatabaseHR.pdf file). Write a query to show employee id, last name, first
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am