SQL Query Examples

Quick answer

SQL query examples are one of the fastest ways to learn SQL because they show what a real query looks like, what it does, and what result it returns.

Instead of memorizing definitions only, you can learn SQL by seeing patterns like:

• SELECT to retrieve data
• WHERE to filter data
• ORDER BY to sort results
• GROUP BY to summarize rows
• JOIN to connect tables
• INSERT, UPDATE, and DELETE to change data

In this guide

Sample tables

To keep the examples consistent, imagine you have these two tables.

employees

departments

SELECT example

The simplest SQL query retrieves columns from a table.

SELECT name, salary
FROM employees;

This returns the name and salary columns for every row in the table.

WHERE example

A WHERE clause filters the rows before they are returned.

SELECT name, salary
FROM employees
WHERE salary > 60000;

This returns only employees whose salary is greater than 60000.

ORDER BY example

ORDER BY controls the sort order of the results.

SELECT name, salary
FROM employees
ORDER BY salary DESC;

This sorts the highest salary first.

GROUP BY example

GROUP BY is used when you want one summary row for each category.

SELECT department, COUNT(*) AS employee_count
FROM employees
GROUP BY department;

This returns one row per department, along with the number of employees in each department.

JOIN example

A join connects rows from two tables using a related column.

SELECT e.name, e.department, d.manager
FROM employees e
INNER JOIN departments d
  ON e.department = d.department;

This returns each employee alongside the manager for that employee’s department.

INSERT example

INSERT adds a new row to a table.

INSERT INTO employees (employee_id, name, department, salary, city)
VALUES (6, 'Felix', 'Sales', 61000, 'Phoenix');

This creates a brand-new row for Felix.

UPDATE example

UPDATE changes existing rows.

UPDATE employees
SET city = 'Boston'
WHERE employee_id = 2;

This changes Ben’s city to Boston.

DELETE example

DELETE removes rows from a table.

DELETE FROM employees
WHERE employee_id = 3;

This removes Chris from the table.

How to study SQL query examples

Many beginners look at a query example and try to memorize the exact wording. That is usually the wrong approach.

A better way is to break each query into parts:

Common mistakes

• copying a query example without understanding what each line does
• using SELECT * in every situation
• forgetting that WHERE filters rows before results are returned
• using ORDER BY when GROUP BY was really needed, or vice versa
• running UPDATE or DELETE examples without understanding the risk of missing WHERE clauses

Practice questions

Bottom line

SQL query examples are useful because they show both the structure and the purpose of real queries.

Once you can read example queries and understand why each clause is there, SQL gets much easier.

Related SQL tutorials