I have a question about mysql. obtain the maximum value of a field in the query result. (sort by other fields)

Ask a mysql question. obtain the maximum value of a field in the query result .. (sort by other fields) This post is finally edited by anyilaoliu from 2013-05-2116:21:32 every time you ask for help. this issue is quite embarrassing... & nbsp; but it is often too late to find a way to check the manual... & nbsp; I had to ask another mysql question. obtain the maximum value of a field in the query result .. (sort by other fields)
At last, this post was edited by anyilaoliu at 16:21:32. every time I asked for help, I was very embarrassed... but I often had no time to look up the manual to find a solution... so I had to extend my hand...

This is the problem. perform a regular query and sort by field a in reverse order. However, you want to obtain the maximum value of field B in this query.

Php does not seem to provide a function to directly obtain the maximum key value of a multi-dimensional array .. it's not impossible to write and sort by yourself, but I still want to ask if I can find it directly on the mysql side (and there cannot be too much performance loss; otherwise, I 'd better use php to calculate it)

Thank you for querying the maximum value of mysql:
------ Solution --------------------
Mysql provides max functions, but this is a clustering function and is not suitable for your scenarios.

Isn't there a loop to retrieve data? In the Loop, is it okay if I use the max function?