Page 1 of 1

Alias or view?

PostPosted: Sat Jan 26, 2008 12:15 am
by romeshijamba
select A.salary,name from ( select distinct salary from employee) A
where some condition

I am having a doubt in this query. it is that what will this "A" be?
will it be a view or an alias. and can i be able to select the name from A?
anyone please help me out.

Re: alias or view?

PostPosted: Sat Jan 26, 2008 12:33 am
by dick scherrer
Hello,

What happened when you tried to run this?

I believe that "A" is neither a view nor an alias (at least not the db2 entities of those names).

This convention is most often when there are multiple tables and someone dles not want to repeat the "long" table name as a qualifier.