how??

I know ename, deptno and sal of employees who has minimum salary in their department.
I use pair-wise subquery.

SQL> select ename, deptno, sal
  2 from emp
  3 where (deptno, sal) in (select deptno, min(sal)

  4                              from emp
  5                              group by deptno);

I want to know ename, deptno and sal
of employees who are paid less than average salary in their deptartment.

What should I do? please help me~~ Received on Fri Aug 24 2001 - 07:04:43 CEST