HOME       >>       Programming

Mysql - Max(concat()) Can anyone explain


electron

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
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 :
http://forums.xisto.com/no_longer_exists/

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



VIEW DESKTOP VERSION REGISTERGET FREE HOSTING

Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.