SQL Online Compiler

Run SQL queries online with our database query tool. Perfect for learning database management, testing SQL queries, and practicing data manipulation.

sql Online Compiler

-- SQL Online Compiler
-- Welcome to SQL practice environment

-- Create a sample table
CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    department VARCHAR(50),
    salary DECIMAL(10,2),
    hire_date DATE
);

-- Insert sample data
INSERT INTO employees (id, name, department, salary, hire_date) VALUES
(1, 'John Doe', 'Engineering', 75000.00, '2023-01-15'),
(2, 'Jane Smith', 'Marketing', 65000.00, '2023-02-20'),
(3, 'Mike Johnson', 'Engineering', 80000.00, '2022-11-10'),
(4, 'Sarah Wilson', 'HR', 60000.00, '2023-03-05'),
(5, 'David Brown', 'Sales', 70000.00, '2022-12-01');

-- Basic SELECT queries
SELECT * FROM employees;

-- Filter by department
SELECT name, salary 
FROM employees 
WHERE department = 'Engineering';

-- Calculate average salary by department
SELECT department, AVG(salary) as avg_salary
FROM employees 
GROUP BY department
ORDER BY avg_salary DESC;

-- Find employees hired in 2023
SELECT name, hire_date
FROM employees
WHERE YEAR(hire_date) = 2023;

-- Update salary
UPDATE employees 
SET salary = salary * 1.10 
WHERE department = 'Engineering';

-- Join example (self-referencing for demonstration)
SELECT e1.name as employee, e2.name as colleague
FROM employees e1, employees e2
WHERE e1.department = e2.department 
AND e1.id != e2.id
LIMIT 5;

-- Aggregate functions
SELECT 
    COUNT(*) as total_employees,
    MAX(salary) as highest_salary,
    MIN(salary) as lowest_salary,
    AVG(salary) as average_salary
FROM employees;

Output

Click "Run" to execute your code and see the output here...

-- SQL Online Compiler
-- Welcome to SQL practice environment

-- Create a sample table
CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    department VARCHAR(50),
    salary DECIMAL(10,2),
    hire_date DATE
);

-- Basic SELECT queries
SELECT * FROM employees;

-- Filter by department
SELECT name, salary 
FROM employees 
WHERE department = 'Engineering';

-- Calculate average salary by department
SELECT department, AVG(salary) as avg_salary
FROM employees 
GROUP BY department
ORDER BY avg_salary DESC;

-- Find employees hired in 2023
SELECT name, hire_date
FROM employees
WHERE YEAR(hire_date) = 2023;

-- Update salary
UPDATE employees 
SET salary = salary * 1.10 
WHERE department = 'Engineering';

-- Join example (self-referencing for demonstration)
SELECT e1.name as employee, e2.name as colleague
FROM employees e1, employees e2
WHERE e1.department = e2.department 
AND e1.id != e2.id
LIMIT 5;

-- Aggregate functions
SELECT 
    COUNT(*) as total_employees,
    MAX(salary) as highest_salary,
    MIN(salary) as lowest_salary,
    AVG(salary) as average_salary
FROM employees;

SQL Compiler Features

Standard SQL syntax support
DDL and DML operations
Joins and subqueries
Aggregate functions
Query optimization tips

About SQL

SQL (Structured Query Language) is the standard language for managing and manipulating relational databases. It's essential for data analysis, database administration, and backend development.

SQL allows you to create, read, update, and delete data in databases, as well as define database structure and manage user permissions. It's widely used across all database systems.

Use our SQL online compiler to practice database queries, learn data manipulation techniques, or test SQL statements without setting up a local database server.