Re: MIN and MAX Query
From: Mike <mike_at_nospam.demon.co.uk>
Date: Thu, 20 Feb 2003 18:28:29 +0000
Message-ID: <fTc2d6AN5RV+Ewa0_at_ntlworld.com>
Date: Thu, 20 Feb 2003 18:28:29 +0000
Message-ID: <fTc2d6AN5RV+Ewa0_at_ntlworld.com>
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 - 19:28:29 CET