ALIAS

ALIAS Clause is used to give another Name to Table or Column. It's like a Shortener, by using Alias we can create a short form of the long or complex table name or column name.

The basic syntax is as follows:

SELECT column_Name FROM tables_Name AS Alias_Name

SELECT column_Name AS Alias_Name FROM tables_Name

Employee
Emp_id	Name	Surname	Salary	Dept_id
1	Rajesh	Khanna	45000	2
2	Sneha	Gupta	55000	4
3	Sandeep	Nehte	95000	1
4	Kirti	Patil	25000	3
5	Nilesh	Jadhav	45000	3
6	Dipesh	Das	35000	5
7	Kailash	Rane	62000	1
8	Kavita	Deshpande	48000	3
9	Sanjay	Datt	50000	3
10	Shruti	Hasan	78000	1

Department
Dept_id	Dept_Name	Loc_id
1	IT	101
2	EC	108
3	Support	103
4	Managment	105
5	LIC	104

Syntax For SQL:

SELECT e.Name,d.Dept_Name,e.Dept_id FROM employee AS e, department AS d WHERE e.Dept_id=d.Dept_id

After Execute: 

Name	Dept_Name	Dept_id
Sandeep	IT	1
Kailash	IT	1
Shruti	IT	1
Rajesh	EC	2
Dinesh	EC	2
Kirti	Support	3
Nilesh	Support	3
Kavita	Support	3
Sanjay	Support	3
Sneha	Management	4