64. Column Aliases with AS

The AS Keyword

AS gives a column a temporary name (alias).

Syntax

1SELECT column AS alias_name FROM table;

Example

1SELECT name AS student_name FROM students;

Result

Why Use Aliases?

• More readable column names
• Required for calculated columns
• Shorter names for long columns