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

Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1111
SQL>select ename,sal,comm,sal+nvl(comm,0) as NetPay from emp
where sal+nvl(comm,0) >any (select sal from emp)

Comments or Responses

Login to post response