Re: how??

crsoza_at_hotmail.com (C. R. Soza) wrote in message news:<c18ea449.0108290742.1e2995e3_at_posting.google.com>...
> select a.ename, a.deptno, a.sal
> from emp a, (select deptno, avg(sal) sal
> from emp
> group by deptno) b
> where a.deptno = b.deptno
> and a.sal <= b.sal
> /

OR

select e1.deptno, e1.ename, e1.sal
from emp e1
where e1.sal < (select avg(e2.sal)

                from emp e2 
		where e1.deptno=e2.deptno
		group by e2.deptno);

Allan W. Tham
DBA Received on Thu Aug 30 2001 - 08:33:22 CEST