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!