What is the fine-grained topic of the following text: I've tried something like this: select hostname,testname,status,max(time) from gms_tests group by hostname,testname but the data returned in the status column is not correct - it doesn't match the status that corresponds with the latest test time. Only return the topic.
Troubleshooting SQL Query on Test Data Status