SQL Aliases

 SQL aliases are used to give a temporary name to a table or a column. This temporary name is only valid within the scope of the SQL query. Aliases are often used to make column names more readable, shorten table names, or improve query clarity.

Column Aliases

Column aliases are used to rename a column's output in the result set. This is particularly useful when:

• You want to make the column names in the output more user-friendly.
• You are performing calculations or transformations on the data.

Syntax:

SELECT column_name AS alias_name
FROM table_name;

Example:

SELECT first_name AS "First Name", last_name AS "Last Name"
FROM employees;

Notes:

• The AS keyword is optional, so SELECT first_name "First Name" works too.
• If the alias contains spaces or special characters, enclose it in quotes.

---

Table Aliases

Table aliases are used to give a temporary name to a table within the query. This is especially useful in:

• Queries involving multiple tables (e.g., joins).
• Reducing verbosity for long table names.

Syntax:

SELECT column_name
FROM table_name AS alias_name;

Example:

SELECT e.first_name, d.department_name
FROM employees AS e
JOIN departments AS d ON e.department_id = d.department_id;

Notes:

• The AS keyword is optional, so FROM employees e works too.
• Once a table is aliased, you must use the alias instead of the full table name in the rest of the query.

---

Combining Aliases

You can combine column and table aliases in the same query for better readability and conciseness.

Example:

SELECT e.first_name AS "First Name", d.department_name AS "Department"
FROM employees e
JOIN departments d ON e.department_id = d.department_id;

---

Benefits of Using Aliases

• Improved Readability: Simplifies complex queries by using shorter or more descriptive names.
• Clarity: Makes derived data or calculations understandable (e.g., renaming SUM(sales) to Total Sales).
• Efficiency: Reduces typing, especially for long table names in joins or subqueries.