🏷️ Aliases in SQL are temporary names assigned to columns or tables within a query. They improve the readability of query results, simplify complex SQL statements, and make long table or column names easier to reference. Aliases exist only during the execution of a query and do not permanently change the names of database objects.

📖 What are Aliases?

An alias is an alternative name given to a column or table using the AS keyword or by simply placing the alias after the original name. Aliases are commonly used in reports, joins, calculations, and aggregate queries.

📝 Why Use Aliases?

📊 Sample Table

Assume the following Students table:

🏷️ Column Aliases

Column aliases provide temporary names for columns in the query result.

SELECT
    StudentID AS ID,
    Name AS Student_Name,
    Department AS Course
FROM Students;

The output displays the headings ID, Student_Name, and Course instead of the original column names.

Alias Without AS

In most SQL databases, the AS keyword is optional.

SELECT
    StudentID ID,
    Name Student_Name
FROM Students;

🧮 Aliases for Calculated Columns

Aliases are commonly used to assign meaningful names to calculated values.

SELECT
    Name,
    Marks,
    Marks + 5 AS BonusMarks
FROM Students;

The calculated column appears in the result as BonusMarks.

🏢 Table Aliases

Table aliases create short names for tables, making queries shorter and easier to read. They are especially useful when joining multiple tables.

SELECT
    s.StudentID,
    s.Name,
    s.Department
FROM Students AS s;

Here, s is a temporary alias for the Students table.

🔗 Table Aliases with JOIN

Table aliases become particularly useful when multiple tables are used in the same query.

SELECT
    s.Name,
    d.DepartmentName
FROM Students AS s
JOIN Departments AS d
ON s.Department = d.DepartmentCode;

Instead of repeatedly writing the full table names, the aliases s and d make the query shorter and easier to read.

📝 Aliases with Aggregate Functions

Aggregate functions often return automatically generated column names that are difficult to read. Aliases solve this problem.

SELECT
    COUNT(*) AS TotalStudents,
    AVG(Marks) AS AverageMarks,
    MAX(Marks) AS HighestMarks
FROM Students;

📌 Aliases with Spaces

If an alias contains spaces, enclose it in the appropriate identifier quotes supported by your database system.

SELECT
    Name AS "Student Name",
    Marks AS "Final Marks"
FROM Students;

📊 Column Alias vs Table Alias

💼 Real-World Example

Suppose a university wants to generate a report showing student names, departments, and average scores using user-friendly column headings.

SELECT
    StudentID AS ID,
    Name AS "Student Name",
    Department AS Course,
    Marks AS Score
FROM Students
ORDER BY Score DESC;

The report displays meaningful headings that are easier for end users to understand than the original database column names.

⚠️ Best Practices

🚀 Key Points to Remember