Re: Limitting result without ROWNUM

From: Matthias Matker <kernkoenig_at_arcor.de>
Date: Fri, 19 Jan 2007 22:07:31 +0100
Message-ID: <45b13313$0$30326$9b4e6d93@newsspool1.arcor-online.net>

Vladimir M. Zakharychev schrieb:
>> I have to limit the number of results without using ROWNUM or something
>> like that. One hint was to use "JOIN".
>>
>> I have to select the 10 biggest persons from a table "persons"
>>
>> id, firstname, lastname, size, age
>>
>>
>> WITHOUT using ROWNUM or "limitter" like this.
>>
>> Do you have any idea?
>>
>> Thanks a lot.

>
> Strange requirement - care to explain why?

It forbidden to use such "limiters", we ( students) should do this via a kind of "JOIN". We MUST do so.
I have tried it for hours...

> I'd suggest using RANK() or
> DENSE_RANK() analytic functions for this, but you might consider them
> "limiters", too, so...

That's right ;-)

> How about just fetching the first 10 rows of the > result set and ignoring the rest?

Cannot act like this.

Thanks for your quick reply. Received on Fri Jan 19 2007 - 15:07:31 CST