<-- Chapter 23: SQL Wildcards

SQL Aliases are used to rename a particular table name or column name in a temporary manner. In a SQL statement , any table or column name can be temporary change.

SQL Syntax for Columns :-

SELECT columnname AS columnaliasname
FROM tablename;

SQL Syntax for Tables :-

SELECT columnname(s)
FROM tablename AS tablealiasname;

Lets see an examples from the below table "employees" :-

Alias TABLE COLUMN SQL syntax :-

SELECT `name` AS [Employee Name], `designation` AS [Employee Designation]
FROM `employees`

Now run the above SQL query, we will see the output below :-

Now we can see here, columns "name" and "designation" are renamed temporary to Employee Name and Employee Designation.

Alias TABLE SQL syntax :-

SELECT `emp`.`name`,`emp`.`code` 
FROM `employees` AS `emp`

Now run the above SQL query, we will see the output below :-

Now we can see here, table name "employee" is renamed temporary to "emp" .