title: Retrieve specific rows without using rownum
body: <p>Since I cant use <code>rownum</code> in the query, how can i use <code>rowid</code> to get result from 2nd row until 4th row using <code>rowid</code> or other possible solution apart from <code>rownum</code>.</p>
  
  <p>Here is my current query where it will retrieve 2nd and 4th row:</p>
  
  <pre><code>SELECT * FROM Record a
  WHERE
  2 = (SELECT COUNT (rowid)
                FROM Record b
               WHERE a.rowid &gt;= b.rowid)
  
  UNION 
  
  SELECT * FROM Record a
  WHERE
  4 = (SELECT COUNT (rowid)
                FROM Record c
               WHERE a.rowid &gt;= c.rowid);
  </code></pre>
  
  <p>Maybe there are other better ways to do it? TQ</p>