Paul wrote:
>
>
> DA Morgan <damorgan_at_psoug.org> wrote:
>
>
>>>ROWNUM is a hack that predated analytical SQL extensions, and some of
>>>these extensions do make sence for an end user. Otherwise, how do you
>>>express the query
>
>
>
>>Without using ROWNUM please provide the equivalent to the following:
>
>
>
>>SELECT *
>>FROM t
>>WHERE rownum < 37;
>
>
>
>
> At the risk of sounding stupid, what *_exactly_* does this query mean?
>
> The first 37 rows that were inserted into the table?
>
> The first 37 that the system happens to find in RAM or on Disk?
>
>
>
> Paul...
In Oracle it means delete the first 36 rows found: Whichever ones they are.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Oct 04 2005 - 16:11:06 CDT
