Re: Hierarchal queries and order by siblings

[Carel <coteijgeler@xxxxxxxxx>]

You're sure?

Does this not work?

SELECT paren, child
FROM  family
ORDER BY parent, child


Op 28-6-2022 om 21:54 schreef Darren Strong:
> I'd like to do something like the following, where I can sort by the parent, but then within the parent, sort the siblings, but, this violates SQL syntax.  I can choose to sort on one or the other, but not both. Is there a way to do this, or should I use the CTE method when selecting multiple parents?
>
>           select
>              connect_by_root(BPROD) as TOPPARENT,
>              level as CurLVL,
>              bchld as Child
>          from MBM
>          start with BPROD in (select PROD from PARTLIST)
>          connect by nocycle prior BCHLD=BPROD
>         order by connect_by_root(BPROD), siblings by BSEQ