title: Select numbers between a range (1 to 100) in sqlite
body: <p>I know some of the solutions in SQL but couldn't find any of them from SQlite. </p>
  
  <p>I just want to execute a select query that returns a resultset of numbers ranging from 1 to 100. </p>
  
  <pre><code>Numbers
    1
    2
    3
    4
    ......
    5
  </code></pre>
  
  <p>A correction:  I don't actually have a table at all. (however a solution is encouraged with a virtual table like <code>dual</code> in MySQL)</p>