title: How to use ROW_NUMBER in sqlite
body: <p>Here is my query given below.</p>
  
  <pre><code>select * from data where value = "yes";
  </code></pre>
  
  <p>My id is auto increment and below there is result of given query.</p>
  
  <pre><code>id || value 
  1  ||   yes
  3  ||   yes
  4  ||   yes
  6  ||   yes
  9  ||   yes
  </code></pre>
  
  <p>How to use ROW_NUMBER in sqlite? So that i can get result which is given below.</p>
  
  <pre><code>NoId || value 
  1    ||   yes
  2    ||   yes
  3    ||   yes
  4    ||   yes
  5    ||   yes
  </code></pre>
  
  <p>ROW_NUMBER AS NoId.</p>