Original Post:

http://bytes.com/topic/oracle/answers/631642-top-10-rows#post2501910

For top row just use the magic column rownum:

SELECT * FROM your_table WHERE rownum <= 10;

If you want bottom row you can order it before (using ORDER BY your_field DESC)