SQL Online Editor

Write and run SQL queries directly in your browser. Perfect for learning SQL and testing queries.

SQL Editor Ready

-- Create a sample table
CREATE TABLE IF NOT EXISTS products (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    price REAL,
    quantity INTEGER
);

-- Insert some data
INSERT INTO products (name, price, quantity) VALUES
    ('Laptop', 999.99, 10),
    ('Mouse', 29.99, 50),
    ('Keyboard', 79.99, 30),
    ('Monitor', 299.99, 15),
    ('Headphones', 149.99, 25);

-- Query the data
SELECT * FROM products;

-- Aggregate query
SELECT
    COUNT(*) as total_products,
    SUM(price * quantity) as inventory_value,
    AVG(price) as average_price
FROM products;

Output:

Output will appear here...

About SQL

SQL (Structured Query Language) is the standard language for managing and manipulating relational databases. This editor uses SQLite, a lightweight, serverless database engine that runs entirely in your browser.

Why SQL?

Universal - Works with all relational databases
Declarative - Describe what you want, not how to get it
Powerful - Complex queries in simple statements
Essential - Required skill for developers and data analysts

Common Use Cases

Data Analysis and Reporting
Database Design and Modeling
Backend Development
Data Migration
Business Intelligence

Quick Start Example

Here’s a simple SQL session to get you started:

-- Create a table
CREATE TABLE users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT UNIQUE,
    age INTEGER
);

-- Insert data
INSERT INTO users (name, email, age) VALUES
    ('Alice', 'alice@example.com', 30),
    ('Bob', 'bob@example.com', 25),
    ('Charlie', 'charlie@example.com', 35);

-- Query data
SELECT * FROM users WHERE age > 25;

SQL Features

SELECT - Retrieve data from tables
INSERT - Add new records
UPDATE - Modify existing records
DELETE - Remove records
JOIN - Combine data from multiple tables
GROUP BY - Aggregate data
ORDER BY - Sort results

SQLite Specifics

This editor uses SQLite which supports:

Standard SQL syntax
Common data types (INTEGER, TEXT, REAL, BLOB)
Indexes and constraints
Transactions
Views and triggers

Learning Resources

SQLite Official Documentation