If we want to give temporarily name to a table then we can do easily with " as " statement .
Sometime permanent name of table is very confusing so we need temporary name of table to make easy understanding .
Syntax
select old_col_name as new_col_name from table_name ;
Example ->
Table name -> student
**Student_name** **Student_Age** **Student_Id**
Mukesh 23 1
Ayush 24 2
Ishan 20 4
Pranav 35 7
Abhishek 26 8
Ravi 25 3
If i want to change( temporary ) the name of the table Student_name , Student_Age ;
select Student_name as Name Student_Age as Age from student ;
outpute->
**Name** **Age** **Student_Id**
Mukesh 23 1
Ayush 24 2
Ishan 20 4
Pranav 35 7
Abhishek 26 8
Ravi 25 3
0 Comment(s)