oracle sql find top level part in multilevel structure

Question

I would like to ask you to help me to find top level id from multilevel structure.

my code is:

SELECT level,id_component, CONNECT_BY_ROOT id_part
  FROM structure
   START WITH id_component = '123'
CONNECT BY PRIOR id_part = id_component

this give me result like:

level id_component id_part
----- ------------ -------
1         123        770
2         770        771
3         771        778
3         771        880

but I need only two id_part from level 3 (778 and 880)

many thanks

There is no way the query you posted gives you the result you posted. You start with id_component = '123456', I don't see that in the output. Also, the query includes SYS_CONNECT_BY_PATH in the SELECT clause - where is that column in the output? How can we take you seriously? — user5683823
– user5683823, Commented Jan 30, 2018 at 20:04
did you notice the Answer already posted? Is that what you need? — user5683823
– user5683823, Commented Jan 30, 2018 at 20:25

user5683823 · Accepted Answer · 2018-01-30 20:03:31Z

2

Add

where connect_by_isleaf = 1

right after the FROM clause and before CONNECT BY.

answered Jan 30, 2018 at 20:03

user5683823

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

oracle sql find top level part in multilevel structure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related