2. Write a query that displays name of employee and commission for all employees who have been employed for more than 240 months, if an employee does not earn commission show "NO COMM".

use oracle sql command line which has HR schema to display this query.

2. Write a query that displays name of employee and commission for all<br>employees who have been employed for more than 240 months, if an<br>employee does not earn commission show

Extracted text: 2. Write a query that displays name of employee and commission for all employees who have been employed for more than 240 months, if an employee does not earn commission show "NO COMM".

Jun 05, 2022

SOLUTION.PDF

2. Write a query that displays name of employee and commission for all employees who have been employed for more than 240 months, if an employee does not earn commission show "NO COMM".

Get Answer To This Question

Related Questions & Answers

Submit New Assignment