vikas_lomate

 Profile Answers by vikas_lomate 

• Feb 25th, 2010

 

select x.ename,x.empno,x.sal,x.deptno from emp x,
(select deptno,avg(sal) avg_sal from emp group by deptno) y
where x.deptno = y.deptno
and   x.sal    < avg_sal
order by deptno;

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Feb 26th, 2010

 

select *
from employees
where salary <
                       (select avg(salary)
                        from employees) --------     displays emp details whose salary is less
                                                                   than avg(salary).


Regards
Dharmendra Jaiswal

deepikazain

 Profile Answers by deepikazain Questions by deepikazain

• Feb 27th, 2010

 

SELECT * FROM employee WHERE sal < (SELECT avg(sal) FROM emp)

rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• May 16th, 2010

 

select e.* from employee e, department d where e.deptID=d.deptID and e.salary<(select avg(salary) from employee where deptID=e.deptID)

g.sreemayee

 Profile Answers by g.sreemayee 

• May 19th, 2010

 

SELECT * FROM emp e WHERE sal> (SELECT AVG(sal) FROM emp GROUP BY deptno HAVING deptno=e.deptno) ORDER BY deptno;

dj_dj_dj

 Profile Answers by dj_dj_dj 

• May 20th, 2010

 

select emp_name, avg(salary)
from employees
group by emp_name
having avg(salary) < (Select avg(salary)
                                  from employees)