SQL: SELECT, WHERE, and ORDER BY

Structured Query Language (SQL) is the standard language for interacting with relational databases. SQL allows you to retrieve, insert, update, and delete data. This lesson covers the most fundamental retrieval operations.

---

The SELECT Statement

The SELECT statement retrieves data from one or more tables.

Basic Syntax

SELECT column1, column2, ...
FROM table_name;

Select All Columns

SELECT *
FROM Students;

The asterisk (*) selects every column. In production code, it is better to name specific columns for clarity and efficiency.

Select Specific Columns

SELECT FirstName, Surname, DateOfBirth
FROM Students;

This returns only the three named columns.

Aliases

You can rename columns in the output using AS:

SELECT FirstName AS "First Name", Surname AS "Last Name"
FROM Students;

DISTINCT

To remove duplicate rows from the results:

SELECT DISTINCT FormGroup
FROM Students;

This returns each unique form group only once.

---

The WHERE Clause

The WHERE clause filters rows based on a condition. Only rows that satisfy the condition are returned.

Basic Syntax

SELECT column1, column2
FROM table_name
WHERE condition;

Comparison Operators