Hi,

I needed to take the ,"The Rows Holding the Group-wise Maximum of a Certain Field"

I can use subqueries but it is supported after 4.1
Trap17 has only 4.0.27.
So no subqueries.

Also you may use a TEMPORARY TABLE.But it is insecure(I am still waiting for a reply in the topic I posted).

Now i found a new way.
MAX(CONCAT) Trick they say.
But i cant understand it.Please explain.

The link to the example and the QUERY :
http://dev.mysql.com/doc/refman/4.1/en/exa...-group-row.html

Please help me.
It is going over my head.
The ADMINS must be knowing about this.