Db2 Developer-C 11.1
Firebird 3.0
MariaDB 10.2 (unavailable)
MariaDB 10.3
MariaDB 10.4
MariaDB 10.5
MariaDB 10.6
MySQL 5.5
MySQL 5.6
MySQL 5.7
MySQL 8.0
Oracle 11g Release 2
Oracle 18c
Oracle 21c
Postgres 8.4 (unavailable)
Postgres 9.4 (unavailable)
Postgres 9.5
Postgres 9.6
Postgres 10
Postgres 11
Postgres 12
Postgres 13
Postgres 14
SQLite 3.8 (unavailable)
SQLite 3.16 (unavailable)
SQLite 3.27
SQL Server 2012 (unavailable)
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2017 (Linux)
SQL Server 2019
SQL Server 2019 (Linux)
YugabyteDB 2.6
YugabyteDB 2.8
No sample DB
run
clear
markdown
compare
help
best fiddles
feedback
Fiddle Statistics
MySQL 8.0
SQLite 3.27
Oracle 18c
Firebird 3.0
MariaDB 10.4
MySQL 5.7
MySQL 5.6
MySQL 5.5
MariaDB 10.3
Db2 Developer-C 11.1
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2017 (Linux)
SQL Server 2019 (Linux)
SQL Server 2019
YugabyteDB 2.8
Oracle 21c
MariaDB 10.5
Oracle 11g Release 2
Node.js 18
MariaDB 10.6
YugabyteDB 2.6
Postgres 12
Postgres 9.5
Postgres 11
Postgres 10
Postgres 9.6
Postgres 13
Postgres 14
≡
clear
markdown
feedback
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
3609995 fiddles created (46903 in the last week).
select version();
version
PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
…
hidden batch(es)
CREATE TABLE meal ( mname TEXT NOT NULL );
✓
hidden batch(es)
CREATE TABLE drink ( dname TEXT NOT NULL )
✓
hidden batch(es)
INSERT INTO meal (mname) VALUES ('Omlette'), ('Fried Egg'), ('Sausage');
3 rows affected
hidden batch(es)
INSERT INTO drink (dname) VALUES ('Coffee'), ('Tea'), ('Orange Juice');
3 rows affected
hidden batch(es)
SELECT * FROM meal, drink;
mname
dname
Omlette
Coffee
Omlette
Tea
Omlette
Orange Juice
Fried Egg
Coffee
Fried Egg
Tea
Fried Egg
Orange Juice
Sausage
Coffee
Sausage
Tea
Sausage
Orange Juice
…
hidden batch(es)
SELECT * FROM meal CROSS JOIN drink;
mname
dname
Omlette
Coffee
Omlette
Tea
Omlette
Orange Juice
Fried Egg
Coffee
Fried Egg
Tea
Fried Egg
Orange Juice
Sausage
Coffee
Sausage
Tea
Sausage
Orange Juice
…
hidden batch(es)
SELECT m.mname, d.dname FROM meal m CROSS JOIN drink d;
mname
dname
Omlette
Coffee
Omlette
Tea
Omlette
Orange Juice
Fried Egg
Coffee
Fried Egg
Tea
Fried Egg
Orange Juice
Sausage
Coffee
Sausage
Tea
Sausage
Orange Juice
…
hidden batch(es)
SELECT m.mname, d.dname FROM meal m JOIN drink d ON TRUE; -- or 1 = 1;
mname
dname
Omlette
Coffee
Omlette
Tea
Omlette
Orange Juice
Fried Egg
Coffee
Fried Egg
Tea
Fried Egg
Orange Juice
Sausage
Coffee
Sausage
Tea
Sausage
Orange Juice
…
hidden batch(es)