Alias or view?
Posted: Sat Jan 26, 2008 12:15 am
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.
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.