Re: PUBLIC:Re: Top 10

From: rsenn <rsenn_at_capaccess.org>
Date: 1997/12/29
Message-ID: <34A875F2.D0C12FEA@capaccess.org>#1/1

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