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

From: Dieter Oberkofler <dtr_at_leadingbits.via.at>
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

Original text of this message