Problem with test top list

Databases
1

Hello,

I have table with test results. Every user have 3 records in the table RESULTS, but I need query to select only one(best) result for every user.

Table RESULTS contains fields USERID (int), TEST_POINTS (int), TEST_TIME (int);

I need query to sort up results, but only the best result per user.
Best result for user is one with MAX points for less (MIN) time. So if there are two or more users with the same POINTS, the better one is one with smaller time.
Sorry for my bad english and tnx!

2 
SELECT m.userid
     , m.max_pts
     , MIN(results.test_time) AS min_time
  FROM ( SELECT userid
              , MAX(test_points) AS max_pts
           FROM results
         GROUP
             BY userid ) AS m
INNER
  JOIN results
    ON results.userid = m.userid
   AND results.test_points = m.max_pts
GROUP
    BY m.userid
     , m.max_pts
3

r937, tnx! That is logic I needed badly :slight_smile: