Why do we use alias for the table name? What is its importance?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 3rd, 2010

Alias is a alternate name given to a table for multiple purposes.The scope of the Alias is within the queryAlias is used to give short name to the table.Used when same table is used n number of times in a query. Alias is used in such queries to give unique name to each table reference. 

goksn

 Profile Answers by goksn Questions by goksn

• Sep 23rd, 2009

-is a shorthand notation-Will be used along with column name if same colum name present in more than one table (while joining those tables)-Must in self join

Answer Question  Select Best Answer