Oracle SQL Display the employee_id manager ID and commis.pdf
advanceg
6 views
1 slides
Mar 22, 2023
Slide 1 of 1
1
About This Presentation
Oracle SQL - Display the employee_id, manager ID, and commission percentage of all employees
from the employees table in departments 10 and 90. Display the manager ID in an additional
column called New Column. If they dont have a manager, display the commission percentage. If
they dont have a commis...
Oracle SQL - Display the employee_id, manager ID, and commission percentage of all employees
from the employees table in departments 10 and 90. Display the manager ID in an additional
column called New Column. If they dont have a manager, display the commission percentage. If
they dont have a commission, display 99999. Use the coalesce function..
Size: 23.15 KB
Language: en
Added: Mar 22, 2023
Slides: 1 pages
Slide Content
Oracle SQL - Display the employee_id, manager ID, and commission percentage of all employees
from the employees table in departments 10 and 90. Display the manager ID in an additional
column called New Column. If they dont have a manager, display the commission percentage. If
they dont have a commission, display 99999. Use the coalesce function.