Re: MIN and MAX Query
From: Thorsten Kettner <thorsten.kettner_at_web.de>
Date: 21 Feb 2003 02:04:01 -0800
Message-ID: <74a9c367.0302210204.6d5a5808_at_posting.google.com>
Date: 21 Feb 2003 02:04:01 -0800
Message-ID: <74a9c367.0302210204.6d5a5808_at_posting.google.com>
"Matty" <matt_at_slippeddisk.fsnenegspamt.co.uk> wrote in message news:<b33k4t$gsq$1_at_news8.svr.pol.co.uk>...
[Quoted] Hi Matty,
Mike's answer is correct. What error do you get?
Here is the complete statement:
select
empno, ename, sal
from
emp
where
sal = (select max(sal) from emp) or
sal = (select min(sal) from emp);
Received on Fri Feb 21 2003 - 11:04:01 CET