Page 1 of 1
What is it - Alias, view, table or something else?
Posted: Fri Jan 17, 2014 4:51 pm
by Atif Alam
Hi,
In the following SQL
Code: Select all
SELECT A.bonus, emp_name from (SELECT DISTINCT BONUS FROM EMP) A
where some condition
In above what will the "A" be? Should it be a VIEW, ALIAS or something else.
Re: What is it - Alias, view, table or something else?
Posted: Fri Jan 17, 2014 5:42 pm
by zprogrammer
A ==> Is a correlation name
Re: What is it - Alias, view, table or something else?
Posted: Wed Jan 22, 2014 12:36 pm
by Atif Alam
Is not it a symbolic name? I was searching for the documentation to din it but in vain.
I'll search again and if could find a document will let you know, in case if you have it with you..please share.
Re: What is it - Alias, view, table or something else?
Posted: Wed Jan 22, 2014 2:22 pm
by zprogrammer