SQL Select As

SQL Select As is used to assign temporary name to table column.

It helps in making easy presentation of result of table.

Take table Student

Student_id Student_name Date_of_brith
23 Rahul 26-08-1994
24 Karan 14-10-1992
25 Ajay 17-02-1995


SQL Query Using As



SELECT Student_id As ID, Student_name As Name, Date_of_birth as DOB FROM Student;



Output

ID Name DOB
23 Rahul 26-08-1994
24 Karan 14-10-1992
25 Ajay 17-02-1995

Back To Top