Skip to content
Advertisement

Average of multiple columns

I have a table called Request and the data looks like:

Now I want to display the average of R1,R2,R3,R4 and R5

So I wrote a query like:

But I just get the sum of R1,R2,R3,R4 and R5 not the average? Where am I doing wrong.

Advertisement

Answer

If the data is stored as INT, you may want to try

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement