Oracle SQL Display the employee_id manager ID and commis.pdf

advanceg 6 views 1 slides Mar 22, 2023
Slide 1
Slide 1 of 1
Slide 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...


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.
Tags