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

 

Reply via email to