How to retrieve the row which has a maximum value in a result of GROUP BY ?

[Pankaj Yadav_1]

But has it got any other significance apart from renaming "object_id" ?

[spex]

No.

[Pankaj Yadav_1]

But my actual query is not working -->

SELECT id,arrivedt,name,startdt,expiredt FROM act_log WHERE id IN(SELECT MAX(id) FROM act_log GROUP BY name) AND keywords REGEXP '".$keywords[0]."' OR keywords REGEXP'".$keywords[1]."' OR keywords REGEXP'".$keywords[2]."' AND csol='$csolnum'
ORDER BY name

Please tell me why its not working ?

[Pankaj Yadav_1]

My MySQL server is old version so it doesn't support the complex query above.

UI have upgraded my server now.