title: Oracle doesn't Support TOP
body: <p>We cannot use <code>TOP</code> command in SQL in ORACLE to get the top n sorted rows,as it doesn't support it. But there are ways of getting the result using <code>rank()</code> and <code>rownum()</code> but that requires and inner query. I want to know if there is any other way apart from using <code>rownum()</code>/<code>rank()</code> with inner query.</p>