Facebook
From Emerald Owl, 6 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 241
  1. WITH integer AS
  2.         (
  3.         SELECT  1 AS num
  4.         UNION ALL
  5.         SELECT  num + 1
  6.         FROM    integer
  7.         WHERE   num < 5
  8.         )
  9. SELECT  *
  10. FROM integer