How to display the employee name and annual salary for all employees including commission?

Oracle Apps Interview Questions › Category: SQL › How to display the employee name and annual salary for all employees including commission?
0 Vote Up Vote Down
Questions Master asked 10 years ago

How to display the employee name and annual salary for all employees including commission?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

SELECT ename, 12*(sal+NVL(comm,0)) AS “annual Sal” FROM emp;