title: How to use the same function like Oracle Rownum in MS ACCESS
body: <p>I am encountering a problem, I had done a function that the data can be loaded by detecting scrolling position, the function was made with a SQL statement "Rownum", it only works in Oracle, but not in ACCESS.</p>
  
  <p>I would like to query the data and resort it</p>
  
  <pre><code>ID  value
  1   aa
  3   bb
  </code></pre>
  
  <p>with Rownum we can do like this</p>
  
  <pre><code>NID ID value
  1   1  aa
  2   3  bb
  </code></pre>
  
  <p>how can I write a SQL statement with Microsoft ACCESS</p>