I want to generate a treeview but I have problem with the order of my records.

How can I order a connect by query? I don't want to order all the records set and loose the hierarchy! I want to order each level and keep the hierarchy.

I need help!

Thanks