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.