Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Top-N records.
It works perfectly.
Thanks.
Aldi
>>From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: RE: Top-N records.
>>Date: Mon, 15 Jan 2001 10:11:29 -0800
>>
>> > -----Original Message-----
>> > From: Sachin Puri [mailto:sachin_at_siworldwide.com]
>> > Sent: dimanche, 14. janvier 2001 20:00
>> >
>> > Aldi
>> > I just saw this topic today. I also saw comments of various
>> > dbas regarding
>> > your query but was
>> > not impressed by anyone.
>>
>>I had answered saying exactly the same thing you did, and mentioned as a
>>bonus a different way of doing the query (with an order by sub-select) for
>>Oracle 8i.
>>
>>That wasn't enough to impress you? I'm going to go in a dark room now and
>>hug myself and cry.
>