title: How to generate a list of number in SQL as it was a list of comprehension?
body: <p>In my case, using sql anywhere (sybase).</p>
  
  <p>Something similar to haskell. [1..100].</p>
  
  <p>I don't know how to generate a random simple list of 1 up to 100.</p>
  
  <p>I only could do it doing:</p>
  
  <pre><code>select 1
  union 
  select 2
  union
  select 3
  </code></pre>
  
  <p>Google did not provide any sample, I suspect this feature does not exist.</p>