mysql max function usage

Posted by Simon on Stack Overflow See other posts from Stack Overflow or by Simon
Published on 2010-03-15T21:00:58Z Indexed on 2010/03/15 21:09 UTC
Read the original article Hit count: 462

Filed under:
|
|

the table videos has the folowing feels id,average,name how can i write the query, to select the name of video, which have the max average!!! i can do that vith two queries, by selecting the max(avege) from the table, and then find out the name, where ihe average equal to max!!! but i want to do that in one query!!! help me please!!!

© Stack Overflow or respective owner

Related posts about mysql

Related posts about max