Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Are there sample tables on sqlfiddle

Tags:

sqlfiddle

Are there any default tables on SqlFiddle that I can query from?

I want to try a basic analytical query on a simple table but I don't want to set up the schema and seed data etc.

normally I would do something like select * from all_objects

( http://sqlfiddle.com/ )

like image 764
monkeyhouse Avatar asked Jan 20 '16 13:01

monkeyhouse


People also ask

How does SQL fiddle work?

SQL Fiddle is a free website (sqlfiddle.com), which allows you to create a relational database schema and insert data into tables online. After creating a DB schema and data, you can run SQL queries online using the data. SQL Fiddle supports different database providers, which include Oracle, MySQL, and PostgreSQL.

What is a table sample?

Introduced in SQL Server 2015 TABLESAMPLE is a clause for a query which can be used to select a pseudo-random number of rows from a table, based upon a percentage or a number of rows and an optional seed number – if a repeatable result is required.


2 Answers

  • Auto Shop Database:
    SQL fiddle

  • Library Database:
    SQL fiddle

  • Countries Table:
    SQL fiddle

like image 135
Daniel Käfer Avatar answered Sep 28 '22 01:09

Daniel Käfer


You can use the "View Sample Fiddle" in the SQLFiddle app.

enter image description here

like image 27
Fergus Avatar answered Sep 28 '22 03:09

Fergus