posted 9 years ago
select :name from (select empName from Employee);
Suppose the Inner query (select empName from Employee) gives one name 'XYZ'.
And as we know the Inner query and sub query execute first then why we not write directly
select :name from XYZ inplace of writing select :name from (select empName from Employee);