mAXMINUM salary aVG

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 1132
select ID, Dept_name
from employee a
where a.salary > ( select
avg(b.salary)
from employee b
where b.Dept_name = a.Dept_name
)

Comments or Responses

Login to post response