Re: how to limit the output?

Brian Peasland wrote:

> Try:
>
> SELECT * FROM table WHERE ROWNUM <= 3;
>

On 8.0.5 this doesn't work if you have an ORDER BY clause, because Oracle works out the rownum before it does the ORDER BY.

I've heard that that behaviour has changed in 8.1.5. Can anyone confirm this?
I would _really_ like to use rownums and ORDER BYs.

thanks,

• Kev