Subject Re: Sorting-Problem on recursive query (window functions)
Author
Hi,

This shows how the resulting tree should look like.

A1

 

 

 

B4

 

A3

 

 

 

B1

 

 

 

C5

 

 

C6

 

B2

 

 

 

C3




Therefore the resultset should be ordered like this:
A1
B4
A3
B1
C5
C6
B2
C3

Each level should be sorted alphabetically within the range of the same parent.

Regards,
Josef