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/ )
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.
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.
Auto Shop Database:
SQL fiddle
Library Database:
SQL fiddle
Countries Table:
SQL fiddle
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With