Re: 2nd attempt: Window function SQL - can't quite figure it.

>> Now, why can't I use deptot and stot_per_man aliases in  my query? It
>> would greatly simplify the SQL by removing the need for a subquery (or inline
>> view as Oracle calls them).


> SQL execution of a query is only done once.  Referring to an alias at the
> same level in a query would require some kind of duplication to work.
> Either two phase processing or cloning the subselect that is being alised
> and executing it a second time to be used in the second location.  Neither
> are desirable.


Thanks for the assistance and clarification. Appreciate your time!


Pál



> David J.



--

--

Pál Teleki