Home › Resources & tools › SQL Playground

SQL Playground

The Structured Query Language (SQL) is a language used to manage data held in relational databases.

This tool allows you to create a relational database and query it using SQL.

The database does not persist data between sessions.

SQL query

DROP TABLE IF EXISTS books;

CREATE TABLE books(id INT, name TEXT, author TEXT, year INT);

INSERT INTO books VALUES (1,'The Lord of the Rings','J.R.R. Tolkien',1954);
INSERT INTO books VALUES (2,'The Hobbit','J.R.R. Tolkien',1937);
INSERT INTO books VALUES (3,'Harry Potter and the Philosopher''s Stone','J.K. Rowling',1997);
INSERT INTO books VALUES (4,'Harry Potter and the Chamber of Secrets','J.K. Rowling',1998);

SELECT * FROM books ORDER BY year;

SELECT * FROM books WHERE author = 'J.R.R. Tolkien';1
DROP TABLE IF EXISTS books;
2

3
CREATE TABLE books(id INT, name TEXT, author TEXT, year INT);
4

5
INSERT INTO books VALUES (1,'The Lord of the Rings','J.R.R. Tolkien',1954);
6
INSERT INTO books VALUES (2,'The Hobbit','J.R.R. Tolkien',1937);
7
INSERT INTO books VALUES (3,'Harry Potter and the Philosopher''s Stone','J.K. Rowling',1997);
8
INSERT INTO books VALUES (4,'Harry Potter and the Chamber of Secrets','J.K. Rowling',1998);
9

10
SELECT * FROM books ORDER BY year;
11

12
SELECT * FROM books WHERE author = 'J.R.R. Tolkien';

The SQL query to execute.

Output

Click Execute to run SQL.

All prices listed are in United States Dollars (USD). Visual representations of products are intended for illustrative purposes. Actual products may exhibit variations in color, texture, or other characteristics inherent to the manufacturing process. The products' design and underlying technology are protected by applicable intellectual property laws. Unauthorized reproduction or distribution is prohibited.

SQL Playground

See also