I have a single table which stores entries for Fitness Test scores. Each new test is entered with all scores, a date, a TestID and other fields. If someone takes multiple tests, they will have multiple entries in the table (date and testID will be unique (except many people will have the same date)). How do I get the most recent test for each individual and get all other fields reported as well? I have looked through many forums and all solutions return only the name (grouped) and the date (filtered using max function).
Speak slowly, Im a noob and know nothing about SQL. Thanks.
Ben