SQL ALIAS

SQL ALIAS

SQL 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