jannaat

 Profile Answers by jannaat Questions by jannaat

• Apr 28th, 2008

 

just to have more readability

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 20th, 2008

 

Alias name it temporary name given to a tablen or  columns of a table.
It has its existence until the satement is executed. 

For example in the following example instead of typing tablenames emp and dept every time you may simply use  its alias names.

SELECT a.empno, a.ename, a.sal  , a.job, b.deptno, b.dname
FROM  emp a , dept b
WHERE a.deptno = b.deptno