title: how to get rowNum like column in sqlite IPHONE
body: <p>I have an Sqlite database table like this (<strong><em>with out ascending</em></strong>)</p>
  
  <p><img src="https://i.stack.imgur.com/xHc08.png" alt="enter image description here"></p>
  
  <p>But i need to retrive the table in <strong><em>Ascending order by name</em></strong>, when i set it ascending order the rowId changes as follows in jumbled order</p>
  
  <p><img src="https://i.stack.imgur.com/vxEKW.png" alt="enter image description here"></p>
  
  <p>But i need to retrieve some <strong>limited number of contacts 5</strong> in ascending order every time</p>
  
  <p>like <strong>Aaa - Eeee</strong> and <strong>then Ffff- Jjjjj</strong> ......</p>
  
  <p>but to se**t limits like 0-5 5-10 .... ** it can able using rowids since they are in jumble order</p>
  
  <p>So <strong>i need another column like (rowNum in oracle) wich is in order 1234567... every time as follows</strong> </p>
  
  <p><img src="https://i.stack.imgur.com/yZdYS.png" alt="enter image description here"></p>
  
  <p>how to retrive that column with existing columns </p>
  
  <p><strong><code>Note: WE DONTE HAVE ROWNUM LIKE COLUMN IN SQLITE</code></strong></p>