Subject Re: Sorting-Problem on recursive query (window functions)
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