Aliases and Column Renaming

Aliases temporarily rename columns or tables for better readability using the AS keyword.

SELECT name AS employee_name, salary AS monthly_salary
FROM employees;

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

Aliases are useful in joins, calculations, and for clarity in results.