LR[ora] to list folders with highest numbers of objects within?

Thomas_Gudella_(tgudella_-_(deleted))

Hello,I need a LR that lists the top 20 of folders/containers with the most children in it.It must be some correlation Dtree.DataIA and Dtree.ParentID grouped and sorted - but I'm a SQL novice.Any advice would be appreciated.Best regards, Tom.

Martin_Gäckler

select * from dtree where subtype=0order by childcount descthen restrict the report on 20 itemsHope this helpsMartin