oracle 树sql
时间:2022-03-14 01:45
1 SELECT t.guid, 2 t.name, 3 t.price, 4 t.parentguid 5 FROM test t 6 start with t.parentguid= ‘48D37AB8-EA5D-4D91-9CAA-A986F35891W4‘ 7 connect by t.parentguid=prior t.guid 8 ORDER SIBLINGS BY T.guid
时间:2022-03-14 01:45
1 SELECT t.guid, 2 t.name, 3 t.price, 4 t.parentguid 5 FROM test t 6 start with t.parentguid= ‘48D37AB8-EA5D-4D91-9CAA-A986F35891W4‘ 7 connect by t.parentguid=prior t.guid 8 ORDER SIBLINGS BY T.guid