Column Aliases

How can we give a SQL result column a clearer name?

Beginner⏱ 2 Minutes⭐ 510 XP

🤔 THE QUESTION

How can we give a SQL result column a clearer name?

💡 WHAT IS IT?

The AS keyword renames output columns in the query result without changing the underlying table schema.

🎯 WHAT IS IT USED FOR?

Improving report readability, standardizing naming conventions, disambiguating identical column names.

💻 EXAMPLE

SELECT
name AS employee_name,
salary AS annual_salary
FROM employees;

Practice typing production-grade SQL code for Column Aliases.