title: Oracle: How to return a partial result only?
body: <p>Im using an Oracle database. </p>
  
  <p>In my query 100 rows are fetched. If I want to filter rows between rownum 50 and 60, what would be the query?</p>
  
  <pre><code>SELECT EMPLID, EFFDT, ACTION, ACTION_REASON 
  from JOB where emplid ='12345'
  </code></pre>