Hi,

How to convert the below oracle query that uses start with and connect by
clause to sybase.

Select parent, child from hierrarchy start with parent = 1 connect by prior
child = parent;

Regards,
Sam