Limitting result without ROWNUM

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. Received on Fri Jan 19 2007 - 14:41:21 CST