Re: How to get the first four rows???
Date: 1996/06/11
Message-ID: <31BD2187.10E7_at_leadingbits.via.at>#1/1
David P wrote:
>
> 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
I was using the 'optimizer hints' method to retreieve the 'first 4 rows'. The method does absolutely not work if you 'must' use a non binary sort order (eg. german).
Dieter Oberkofler
Software Engineer
LEADING BITS GmbH. Tel (+43-1) 586 76 11 Schleifmuehlgasse 5/17 Fax (+43-1) 587 76 15 A-1040 Vienna E-mail dtr_at_leadingbits.via.at Austria Compuserve 100141.1314 ------------------------------------------------------------------Received on Tue Jun 11 1996 - 00:00:00 CEST