SQL for Beginners
About Lesson

Alias

You can give a table or a column another name by using an alias. This can be a good thing to do if you have very long or complex table names or column names.

An alias name could be anything, but usually it is short.

 

SQL Alias Syntax for Tables:

SELECT column_name(s) 
FROM table_name
AS alias_name

 

SQL Alias Syntax for Columns:

SELECT column_name AS alias_name 
FROM table_name