WITH cte(n) AS (SELECT 1 UNION SELECT n + 1 FROM cte WHERE n < 10)SELECT n, typeof(n) FROM cte;
Standard input is empty
1|integer 2|integer 3|integer 4|integer 5|integer 6|integer 7|integer 8|integer 9|integer 10|integer
The brand new service which powers Ideone!
Widget for compiling and running the source code in a web browser!