fork download
copy 
  1. WITH cte(n) AS (SELECT 1 UNION SELECT n + 1 FROM cte WHERE n < 10)
  2. SELECT n, typeof(n) FROM cte;
Success #stdin #stdout 0s 4344KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
1|integer
2|integer
3|integer
4|integer
5|integer
6|integer
7|integer
8|integer
9|integer
10|integer
https://ideone.com/t2cZZI
language:
SQLite (sqlite 3.27.2)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!