SQL - Aliases

Overview

Aliases rename columns or tables for readability. Use AS (optional in many engines).

SELECT e.first_name AS name, d.name AS department
FROM employees AS e
JOIN departments AS d ON d.id = e.department_id;

SELECT e.first_name AS name, d.name AS department
FROM employees AS e
JOIN departments AS d ON d.id = e.department_id;

SELECT e.first_name AS name, d.name AS department
FROM employees AS e
JOIN departments AS d ON d.id = e.department_id;