Re: Limitting result without ROWNUM

Matthias Matker wrote:
> Hello together,
>
> 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.

Giving students problems that have no bearing on the real-world is a huge waste of time.

Perhaps your instructor would like to contact me. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org