Re: How to get the first four rows???

On 4 Jun 1996 19:24:18 GMT, austin_at_inmind.com (Michael E. Austin) wrote:

>If you were using something like OracleRDB, you could say:
>
>select * from tablename where ... limit to 4 rows;
>
>:)
>--

Sorry, but there is no such thing as "LIMIT to N rows" in Oracle That subject's been discussed many times, but lacked fastest way to do that
That is:
If u use selects of that kind often, just create index the way u want it to be ordered, use optimizer hints OR don't use hints :) 'cause the way oracle works it'll use index anyway, of course if u will not mix OraOptimizer using wild card charachters Best regards
Dave Received on Sun Jun 09 1996 - 00:00:00 CEST