Re: Question about finding maximum and minimum

From: Gerard M. Averill <e-mail.address_at_my.sig>
Date: Tue, 08 Dec 98 23:39:30 GMT
Message-ID: <74kd6r$15ig$1@news.doit.wisc.edu>

How about:

select min(a), max(a)
from
(

        select t1.a
        from t t1
        where t1.a >= a1 and
              t1.a <= a2

)

---

Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison GAverill<at>chsra<dot>wisc<dot>edu Received on Tue Dec 08 1998 - 17:39:30 CST