Honesty Rocks! truth rules.

Mysql - Max(concat()) Can anyone explain

HOME      >>       Programming



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
Xisto 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 :

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