IBM Mainframe Forum

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.

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.