Max of an Average 1

[gussifinknottle]

I have got a table from which I have obtained average values, based on 'GROUP BY' clause. I need to get the max of these average values and display them.

Is there any way I can do an aggregate of an aggregate, like max of an avg in the same Query?

 

[IonelBurtan]

Yes, as far as know, you should do somethimg like this:

SELECT MAX(x.mymaxfield) FROM (SELECT ... GROUP BY ...) AS X



I mean "SELECT ... GROUP BY ..." is the query that you have until now.

Hope this will help you