How to display employee name, sal, comm and net pay for those employee whose net pay is greater than or equal to any other employee salary of the company?

Oracle Apps Interview Questions › Category: SQL › How to display employee name, sal, comm and net pay for those employee whose net pay is greater than or equal to any other employee salary of the company?

0 Vote Up Vote Down

Questions Master asked 9 years ago

How to display employee name, sal, comm and net pay for those employee whose net pay is greater than or equal to any other employee salary of the company?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 9 years ago

SELECT ename,
sal,
comm,
sal+NVL(comm,0) AS netpay
FROM emp
WHERE sal+NVL(comm,0) >ANY
(select sal from emp
);