Re: SQL/SQL*Plus: How to add numbers to rows?

syakobson_at_erols.com schreef in artikel <877135123.8695_at_dejanews.com>...
> Sorry, but your query will not work.

That's strange, I've tried it. Did you?
>
> You should change where aff.affiliation > e.affiliation(+) to where
> aff.affiliation < e.affiliation(+) then SELECT in FROM clause would
> return total number of employees in all preceding affiliations. For the
> first one it would return 0.
>

I think aff.affiliation < e.affiliation(+) will return the employees in the following affiliations.

-- 
------------
Kind reGards
     \ /   |
      X    |
     / \   x
     Gerard