List:General Discussion« Previous MessageNext Message »
From:Reynier Perez Mira Date:June 17 2007 2:23pm
Subject:Help with AVG query
View as plain text  
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
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?

 

Cheers and thanks in advance

            

 

Reynier Pérez Mira

5to. año Ing. Informática

Universidad de las Ciencias Informáticas

 


Thread
Help with AVG queryReynier Perez Mira17 Jun
  • Re: Help with AVG queryPeter Brawley17 Jun