Johan Höök wrote:
Hi Gobi, there was a similar posting in august. See: http://lists.mysql.com/mysql/187436 which I think describes what you want. I'll include a bit of it here as well ----------This is out of the MySQL class and is called the Max-Concat trick. ________________________________________________________________________ ____ What is the biggest country in each continent? "The Rows Holding the Group-wise Maximum of a Certain Field" MySQL> Select Continent, -> SUBSTRING(MAX(CONCAT(LPAD(Population,10,'0'),Name)),11) AS Country, -> 0+LEFT(MAX(CONCAT(LPAD(Population,10,'0'),Name)),10) AS Population -> From Country -> Group By Continent -> Order By Population DESC; -------------/Johan
Sorry for being slow but this statement is quite confusing and I am having difficulty trying to understand it in order to adapt it to my table. Can you explain it? Thanks.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
