TABLE

id name STATUS fecha
|1| john |ok        |2010-11-18 12:52:42
|1| john |passed    |2010-11-18 12:52:55
|2| joe  |ok        |2010-11-18 12:53:07
|2| joe  |notpassed |2010-11-18 12:53:15
|1| john |aprobed   |2010-11-18 12:54:48

Query
SELECT id, name,
STATUS , MAX( DATE )
FROM tbl
GROUP BY id, name

RETURN
id  name  STATUS  MAX( DATE )
1 john ok 2010-11-18 12:54:48
2 joe ok 2010-11-18 12:53:15

Will be RETURN  (STATUS CHANGE)
id  name  STATUS  MAX( DATE )
1 john aprobed 2010-11-18 12:54:48
2 joe notpassed 2010-11-18 12:53:15