Duplicate row, copy one value into a new column
Posted by:
john huie
Date: February 07, 2017 03:33PM
Hello All,
I am trying to figure out the following:
Sample Data:
Student ID, date, score
11111111, 12/31/2016, 87
11111111, 01/31/2017, 100
I have table with duplicate student id's. I want to find the latest test score (by date) copy that value into a new column that is on the same row as the oldest date? I can't figure where to start? Any ideas?
Thank You
John H
Subject
Written By
Posted
Duplicate row, copy one value into a new column
February 07, 2017 03:33PM
February 07, 2017 06:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.