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
mysql
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