Date: 03/09/07 (MySQL Communtiy)    Keywords: no keywords

I have a table containing test results. 

studentid INT
testscore FLOAT
dateadded DATETIME

There are multiple tests for each student. 

How can I SELECT the most recent test result for each student in the table?  I think I would use GROUP BY studentid, but am a little foggy from there..

thanks!

Source: http://community.livejournal.com/mysql/110603.html