Re: Simple Question!
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/05/02
Message-ID: <Pine.SUN.3.91.950502115438.6617B-100000_at_seatimes>#1/1
Date: 1995/05/02
Message-ID: <Pine.SUN.3.91.950502115438.6617B-100000_at_seatimes>#1/1
>
> SELECT AGE FROM TABLE
> ORDER BY AGE
> WHERE ROWNUM <= 1000;
>
> That way, you order by age, returning the ages in ASC or DESC
> order depending on your chaoice, and filed, AGE_IN_YEARS or
> DATE_OF_BRITH, and the WHERE statement will stop the query when
> you've reached 1000 rows.
Actually, it's in the other order:
It will retrieve the 1000 rows AND THEN SORT 'em. Not what he wanted.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Tue May 02 1995 - 00:00:00 CEST