Hello,
I have a query like this that gives me full hierarchy:
SELECT old, new, date, CONNECT_BY_ISCYCLE "Cycle",LEVEL
FROM table
CONNECT BY NOCYCLE PRIOR new=old
e.g.
| A | B | 20100223 | 0 | 1 |
| B | C | 20120815 | 0 | 2 |
| C | D | 20130318 | 0 | 3 |
what I would like to get is a row like this below for product A. I have a problem with getting last descendant (D in that example)
product 1st descendant last descendant
A B D