SELECT column FROM table WHERE ROWNUM <= 10
Won't give you the expected results in all cases. You need to do something like
select * from ( SELECT column FROM table order by x ) WHERE ROWNUM <= 10
This will ensure all your ordering is done before the limiting bit of the query.
Here are more examples http://www.oracle.com/technology/oramag/oracle/06-sep/o56ask...