Online SQL Compiler

This free online SQL compiler runs SQLite in your own browser. Write CREATE TABLE, INSERT and SELECT statements, press Run, and see each result as a table. Every run starts with a fresh, empty database, so you can try anything without breaking something.

It is made for practising SQL for interviews, college DBMS lab work and data analyst roles.

1. Create a table with CREATE TABLE and add rows with INSERT.
2. Write one or more SELECT queries. End each statement with a semicolon.
3. Press Run. Each SELECT shows its own result table.

Open any of these from the Examples tab in the side bar.

CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  city TEXT,
  marks INTEGER
);

INSERT INTO students (name, city, marks) VALUES
  ('Asha', 'Pune', 82),
  ('Ravi', 'Delhi', 67),
  ('Meera', 'Pune', 91),
  ('Kabir', 'Chennai', 54);

SELECT name, marks FROM students WHERE marks > 60 ORDER BY marks DESC;

CREATE TABLE students (name TEXT, city TEXT, marks INTEGER);
INSERT INTO students VALUES
  ('Asha', 'Pune', 82), ('Ravi', 'Delhi', 67),
  ('Meera', 'Pune', 91), ('Kabir', 'Chennai', 54);

SELECT city, COUNT(*) AS students, ROUND(AVG(marks), 1) AS avg_marks
FROM students
GROUP BY city
ORDER BY avg_marks DESC;

CREATE TABLE courses (id INTEGER PRIMARY KEY, title TEXT);
CREATE TABLE enrolments (student TEXT, course_id INTEGER);

INSERT INTO courses VALUES (1, 'Python'), (2, 'SQL'), (3, 'React');
INSERT INTO enrolments VALUES ('Asha', 1), ('Asha', 2), ('Ravi', 2), ('Meera', 3);

SELECT e.student, c.title
FROM enrolments e
JOIN courses c ON c.id = e.course_id
ORDER BY e.student;

SQL (Structured Query Language) is the language for working with data in tables. Almost every company stores its data in a SQL database, so SQL is asked in interviews for developer, data analyst and data science roles.

This page uses SQLite. SQLite follows standard SQL, so SELECT, WHERE, JOIN, GROUP BY, ORDER BY and subqueries work the same as in MySQL and PostgreSQL. A few details are different, listed in the questions below.

• no such table: studentsEach run starts with an empty database. Put the CREATE TABLE and INSERT statements in the same run as your SELECT.
• near "…": syntax errorCheck for a missing comma between columns or a missing semicolon between statements.
• UNIQUE constraint failedYou inserted a value that already exists in a PRIMARY KEY or UNIQUE column.

• Online Python Compiler
• Online C Compiler
• Online C++ Compiler
• Online Java Compiler
• Online JavaScript Compiler
• Online HTML, CSS and JavaScript Compiler
• Online TypeScript Compiler
• Online React Compiler
• Online Bash Shell Compiler