mysql query clarification

Posted by JPro on Stack Overflow See other posts from Stack Overflow or by JPro
Published on 2010-05-11T12:39:35Z Indexed on 2010/05/11 12:44 UTC
Read the original article Hit count: 377

Filed under:

I have a query which I am wondering if the result I am getting is the one that I am expecting.

The table structure goes like this :

Table :  results     
ID TestCase Set  Analyzed Verdict StartTime             Platform
1  1010101  ros2 false    fail    18/04/2010 20:23:44   P1
2  1010101  ros3 false    fail    19/04/2010 22:22:33   P1
3  1232323  ros2 true     pass    19/04/2010 22:22:33   P1
4  1232323  ros3 false    fail    29/04/2010 22:22:33   P2

Table : testcases
ID TestCase type
1  1010101  NOSNOS
2  1232323  N212NS

is there any way to display only the latest fails on each platform?

in the above case

Result shoud be :

 ID TestCase Set  Analyzed Verdict StartTime             Platform type 
 2  1010101  ros3 false    fail    19/04/2010 22:22:33   P1       NOSNOS 
 4  1232323  ros3 false    fail    29/04/2010 22:22:33   P2       N212NS

© Stack Overflow or respective owner

Related posts about mysql