List all the job groups who average salary exceeds that of managers.

**jaideepu** · 04-28-2009

List all the job groups who average salary exceeds that of managers.

Empno ename job manager hiredate salary deptno commission
7369 smith clerk 7902 12/1/1982 1200 20 null
7499 allen salesman 7698 2/20/1981 1501 30 null
7521 ward salesman 7698 2/22/1981 1600 30 160
7698 black manager 7999 5/1/1981 3850 30 385
7902 ford analyst 7566 12/1/1981 3000 10 300
7688 jones analyst 7698 10/10/2008 4500 10 450
7689 martin clerk 7698 12/12/2004 4525 20 453
7999 scott ceo null 1/1/2001 9999 30 1000
7466 tiger manager 7999 1/1/2004 6500 10 650

**debasisdas** · 04-28-2009

What is the code that you are working on ?

**vikasvaidya** · 04-29-2009

Hi Jai,

The query can be like

Select AvgSal, job from (
select avg(salary) AvgSal, job from [tablename] group by job
) as vw where job<>'manager'
and AvgSal > (Select Avg(Salary) from [tablename] where job='manager')

---V V---
Vikas Vaidya

**Saakha** · 06-26-2009

Select job,avg(salary)from employees where (avg(salary)>(select salary from employees where job=manager) and job not equals 'manager') group by job.

**r.kothandaraman** · 06-26-2009

Select job,avg(salary)from employees where (avg(salary)>(select salary from employees where job=manager) and job not equals 'manager') group by job;

**susarlasireesha** · 06-26-2009

Select job, avgsal
From (Select Avg (sal) avgsal, job
From emp
Group By job),
(Select sal msal
From emp
Where job = 'MANAGER')
Where avgsal > msal And job != 'MANAGER'

**CSOOR** · 06-27-2009

select job, avg(sal ) from emp where job != "MANAGER" group by job
having avg(sal ) > ( select avg(sal) from emp where job = "MANAGER" )

Thread: List all the job groups who average salary exceeds that of managers.

Thread Tools

Display

List all the job groups who average salary exceeds that of managers.

Re: List all the job groups who average salary exceeds that of managers.

Re: List all the job groups who average salary exceeds that of managers.

Re: List all the job groups who average salary exceeds that of managers.

Re: List all the job groups who average salary exceeds that of managers.

Re: List all the job groups who average salary exceeds that of managers.

Re: List all the job groups who average salary exceeds that of managers.

Posting Permissions

About us

GeekInterview

Interact