This is a bit embarrassing because I think this should be a simple WHERE clause, but it escapes me at the moment.
I have a table with data: module_id email score date_time 1 [EMAIL PROTECTED] 8 5/27/2006 12:07 AM 1 [EMAIL PROTECTED] 9 5/27/2006 12:11 AM 1 [EMAIL PROTECTED] 7 5/27/2006 12:14 AM 1 [EMAIL PROTECTED] 8 5/27/2006 9:46 PM 2 [EMAIL PROTECTED] 8 5/27/2006 9:46 PM 1 [EMAIL PROTECTED] 8 5/27/2006 9:46 PM 2 [EMAIL PROTECTED] 7 5/27/2006 9:47 PM 3 [EMAIL PROTECTED] 7 5/27/2006 9:47 PM 3 [EMAIL PROTECTED] 8 5/27/2006 9:50 PM I'm trying to get a list of each persons completed test (module_id), and the score, but only for the latest test result (date_time), not all of them. You can see that Kris and Robert have taken the same test several times. I just want the latest results (even if the score was worse). I'm not sure how to grab the latest? Ultimately, I want my result to look like this module_id email score date_time 1 [EMAIL PROTECTED] 7 5/27/2006 12:14 AM 1 [EMAIL PROTECTED] 8 5/27/2006 9:46 PM 2 [EMAIL PROTECTED] 8 5/27/2006 9:46 PM 1 [EMAIL PROTECTED] 8 5/27/2006 9:46 PM 2 [EMAIL PROTECTED] 7 5/27/2006 9:47 PM 3 [EMAIL PROTECTED] 8 5/27/2006 9:50 PM I looked a few places on google, but they seemed to be suggesting using DESC in the where clause and I didn't see how that was going to work? Any ideas are greatly appreciated! -Brian Menke
