Join Parent Column
158
July 29, 2018, at 06:50 AM
Hi I have a table named Orders that has a parent column which refer to a previous related order.
order_id parent_order_id 2 NULL 3 2 5 3 6 5
I need a query that puts the last order_id against the first one considering the fact that not all orders are like this, some have 2 parents, some 1 and some may have no parents at all. So the number of joins is unknown.
The desirable result for the example above is as follows:
order_id parent_order_id 6 2
Is it possible? Thanks.
-
05:30
-
04:00
-
00:00
-
10:30
-
9:10
-
07:40
Firebase Cloud Functions: PubSub, "res.on is not a function"
-
04:00
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
-
9:20
-
7:40
POPULAR ONLINE
- search for elements in a list 110734 visits
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 107350 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98441 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 95926 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92138 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 61626 visits
- Adding methods to es6 child class 22166 visits
