id,fk_web_project,messageid,subject,priority,messagetext,id,fk_test_message,fk_web_user,fk_test_message_states,creationdate
59,116,130,subject 1,3,[B@efa27e,26,59,1340,1,2012-08-03 14:15:37.0
60,116,134,subject 2,3,[B@951a5f,27,60,1340,1,2012-08-06 10:51:35.0
61,116,135,m1,3,[B@f66add,28,61,1340,1,2012-08-06 11:59:15.0
62,116,135,m2,3,[B@1e1f376,29,62,1340,1,2012-08-06 12:47:21.0
63,116,135,m3,3,[B@136da61,30,63,1340,1,2012-08-06 12:47:36.0
64,116,135,m4,3,[B@3b3acd,31,64,1340,1,2012-08-06 12:54:38.0
65,116,135,m5,3,[B@af05d8,32,65,1340,1,2012-08-06 12:55:10.0

SELECT messageid,subject
FROM gorestabelle
WHERE id IN (
SELECT MAX(id)
FROM gorestabelle
GROUP BY messageid
)