SQL ALIASES can be used to create a temporary name for columns or tables.
⇒ SQL Aliases are used to give an alias name to a table or a column.
⇒ Column Aliases are used to make column headings in the result set easier to read.
⇒ Table Aliases are used to shorten SQL queries to make them easier to read or when more than one table is involved.
Aliases are created to make table or column names easier to read. An alias only exists for the duration of the query. This renaming is just a temporary change, and the actual table name does not change in the database.
Aliases are useful when table or column names are long or not very readable. They are preferred when more than one table is involved in a query.
