Select numbers between a range (1 to 100) in sqlite

Question

I know some of the solutions in SQL but couldn't find any of them from SQlite.

I just want to execute a select query that returns a resultset of numbers ranging from 1 to 100.

Numbers
  1
  2
  3
  4
  ......
  5

A correction: I don't actually have a table at all. (however a solution is encouraged with a virtual table like dual in MySQL)

Answer 1

Thanks sgmentzer! Inspired by your answer I went ahead and also found this:

WITH RECURSIVE
  cnt(x) AS (
     SELECT 1
     UNION ALL
     SELECT x+1 FROM cnt
      LIMIT 100000
  )
SELECT x FROM cnt;

Answer 2

How about

SELECT * FROM myTable WHERE myNumber >= 1 AND myNumber <= 100;

?