Re: Help with AVG query

Reynier, Normally with PHP I add every field, I mean (eval1, eval2, eval3, eval4, eval5) and then divide this result by 5, like a average. I know that SQL can do this directly using AVG function but I don't know how. Can any help me? AVG computes an average across rows. If I understand you c

Help with AVG query

Hi every: I have this table: smp_evaluacion --- id_evaluacion eval1 eval2 eval3 eval4 eval5 This is for a rating system. I need to build a query for retrieve the best rating files. Normally with PHP I add every field, I mean (eval1, eval2, eval3, eval4, eval5) and then