SQL Aliases

When working with databases, table names and column names are not always short or easy to read. Large enterprise databases often contain lengthy names that can make SQL queries difficult to understand and maintain.

For example, a table named:

can make queries unnecessarily long.

Similarly, a column named:

may not look ideal when displayed in reports.

To solve this problem, SQL provides Aliases.

Aliases allow developers to assign temporary names to columns and tables during query execution. These temporary names improve readability, simplify complex queries, and make query results more user-friendly.

Aliases do not permanently change the database structure. They exist only while the query is running.

In this lesson, you will learn what aliases are, why they are useful, how to create column aliases, table aliases, and best practices for using aliases effectively.

What is an Alias?

An Alias is a temporary name assigned to a column or table in a SQL query.

Example:

Here:

is temporarily displayed as:

The actual column name remains unchanged inside the database.

Aliases affect only the query result.

Why Use Aliases?

Aliases provide several benefits.

Improve Readability

Complex names become easier to understand.

Example:

can become:

Simplify Queries

Long table names become shorter.

Example:

can become:

Improve Reports

Displayed column names look cleaner and more professional.

Simplify Joins

Aliases reduce typing when working with multiple tables.

Column Aliases

Column aliases provide temporary names for columns.

Basic syntax:

Example:

Result:

The database still stores the column as Name.

Using Aliases Without AS

The AS keyword is optional in most database systems.

Example:

Produces the same result as:

However, using AS improves readability.

Multiple Column Aliases

Multiple columns can be renamed.

Example:

Result:

This creates cleaner output.

Aliases with Spaces

Aliases can contain spaces.

Example:

Result:

Useful for reports and dashboards.

Aliases with Calculations

Aliases are commonly used with calculated values.

Example:

Result:

The calculated column receives a meaningful name.

Table Aliases

Table aliases assign temporary names to tables.

Basic syntax:

Here:

is temporarily renamed to:

within the query.

Why Use Table Aliases?

Consider a long table name:

Without alias:

With alias:

The query becomes easier to read and write.

Table Alias Example

Example:

Explanation:

• Students is the actual table.
• S is the temporary alias.
• Name is accessed through S.

Result:

Aliases in JOIN Queries

Aliases become especially useful when joining tables.

Example tables:

Students

Courses

Query:

Result:

Without aliases, the query would be much longer.

Self Join Example

Aliases are required in self joins.

Example:

Here:

• E1 represents employees.
• E2 represents managers.

Aliases help distinguish between the two references.

Real-World Example

Imagine an e-commerce platform.

Table:

Query:

Result:

The report becomes more user-friendly.

Aliases and Aggregate Functions

Aliases are frequently used with aggregate functions.

Example:

Result:

Without an alias:

would appear as the column heading.

Common Errors

Using Invalid Alias Names

Wrong:

Some databases reject aliases starting with numbers.

Confusing Aliases with Actual Column Names

Example:

StudentName exists only in the query result.

It is not a real column.

Using Reserved Keywords

Avoid:

Reserved SQL keywords should not be used as aliases.

Best Practices

Use Meaningful Aliases

Good:

Bad:

Use AS for Clarity

Preferred:

instead of:

Keep Table Aliases Short

Examples:

Short aliases improve readability.

Use Aliases in Complex Queries

Aliases become especially valuable when:

• Joining tables
• Using subqueries
• Performing calculations
• Creating reports

Common Interview Questions

What is an Alias in SQL?

An alias is a temporary name assigned to a column or table during query execution.

Does an alias permanently change a column name?

No.

Aliases exist only while the query executes.

What is the purpose of table aliases?

Table aliases simplify queries and improve readability.

Is the AS keyword mandatory?

No.

However, using AS is considered a best practice.

Summary

SQL Aliases provide temporary names for columns and tables, making queries easier to read, write, and maintain. They are especially useful in reporting, calculations, joins, and complex database operations.

In this lesson, you learned:

• What aliases are
• Why aliases are useful
• Column aliases
• Table aliases
• Aliases with calculations
• Aliases in joins
• Aliases with aggregate functions
• Best practices
• Common mistakes

Understanding aliases is important because they help create cleaner, more professional SQL queries and improve the readability of query results.

Next Step

Continue to the next lesson:

WHERE Clause →