Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to update a column(as row number) based on group by

Mahesh GuddetiNov 9 2018 — edited Nov 12 2018

Hi I have data like this. Maste_seq and Child_seq are newly added columns. I need to populate like below.

MASTER ID     CHILD ID    DATE                                   MASTER_SEQ    CHILD SEQ

A                       A1               01-JAN-2014                          1                            1

A                       A2               05-NOV-2016                         1                            2
A                       A3               14-FEB-2018                          1                            3 

B                       B1               01-JAN-2012                          2                           1

B                       B2               05-NOV-2013                         2                           2
B                       B3               14-FEB-2016                          2                           3

I wanted to updated master_seq and child_seq in above order. How can i achieve it? Any help is highly appreciated.
This post has been answered by Frank Kulash on Nov 9 2018
Jump to Answer
Comments
Post Details
Added on Nov 9 2018
17 comments
2,837 views