Avatar of Pete C
Pete C
Flag for United States of America asked on

Find average of max values - mysql

Hi,

I have a routine that returns the max value of each group of records, roughly something as follows:

SELECT max (price) FROM product GROUP BY productcategory;

so, this will return the max price with respect to each product category.  I am actually interested in the average of such max prices.

I would think that there should just be a way to take the average of such results within a mysql statement, but that does not seem to be the case; instead, it seems as though I need to loop through records and calculate the sum and divide it by the recordcount.

Am I missing any obvious solutions?

Thanks,
Pete
Microsoft SQL ServerPHP

Avatar of undefined
Last Comment
Pete C

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kent Olsen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Lowfatspread

what record count are you averaging over?

the count of those with the max values...
or the whole population?
Pete C

ASKER
Thanks - that took care of it!
Your help has saved me hundreds of hours of internet surfing.
fblack61