SQL Aliases

SQL Aliases

SQL aliases are used to give a table, or a column in a table, a temporary name.

Aliases are often used to make column names more readable.

An alias only exists for the duration of that query.

An alias is created with the AS keyword.

Alias for Columns Syntax

SELECT column_name AS alias_name
FROM table_name;

Alias for Tables Syntax

SELECT column_name(s)
FROM table_name AS alias_name;