Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PUBLIC:Re: Top 10
Jomarlen wrote:
> >Try:
> >
> >Select *
> >from xyz
> >where rownum <= 10
> >
> >and you get the first 10 rows of the select result
> >
> >
>
> This comes up at least once a month!
> Sure, it works if you don't include
> an ORDER BY.
>
> If you do then you get the first 10 records
> that would have been retrieved BEFORE
> the ORDER BY is applied. which is probably
> not what you want.
>
> John
How would you solve this? Received on Mon Dec 29 1997 - 00:00:00 CST