MySQL Forums
Forum List  »  Newbie

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

Options: ReplyQuote


Subject
Written By
Posted
Duplicate row, copy one value into a new column
February 07, 2017 03:33PM


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.