Re: how??
From: C. R. Soza <crsoza_at_hotmail.com>
Date: 29 Aug 2001 08:42:43 -0700
Message-ID: <c18ea449.0108290742.1e2995e3_at_posting.google.com>
Date: 29 Aug 2001 08:42:43 -0700
Message-ID: <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
/
Received on Wed Aug 29 2001 - 17:42:43 CEST