Hi!
I need to find leaf levels in an organizational table with some type of query. The rownr are unike. But the leaf level could be found in any level and consist of one or multiple rows before going up one one or many levels and then down to leaf level again. In this example i would like to find rownr, 3, 4, 8, 10 and 11. But my table consist of some thousand units but if a query could find leaf levels for this example i think it should work for table also. I have tried to solve this but i cant find a solution so i hope someone can help me.
Br
Arne
The structure looks like below
Rownr Level
1 1
2 2
3 3
4 3
5 2
6 3
7 4
8 5
9 4
10 5
11 5
