Display those employee whose salary is equal to average of maximum and minimum?

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 3676
SQL>select ename from emp where sal=(select max(sal)+min(sal)/2 from
emp);

Comments or Responses

Login to post response