Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: MIN and MAX Query
In message <3E541FF3.2010206_at_indra.com>, Ron Reidy <rereidy_at_indra.com>
writes
>select max(sal), empno, ename
>from emp
>group by empno, ename
>union
>select min(sal), empno, ename
>from emp
>group by empno, ename
>order by 1
>
>--
>Ron Reidy
>Oracke DBA
>
Err no
That will give you the max sal for each employee ie: everyone !
Cheers
-- Mike CoxReceived on Thu Feb 20 2003 - 12:28:29 CST