Re: MIN and MAX Query

"Matty" <matt_at_slippeddisk.fsnenegspamt.co.uk> wrote in message news:<b33k4t$gsq$1_at_news8.svr.pol.co.uk>...

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 - 04:04:01 CST