Total Pageviews

Wednesday, March 7, 2012

Average of multiple columns

Table name: `boss_bos`

2
4
6
8
10
0
0
3
0
0

To take average


SELECT *,(
`rate1_bos` + `rate2_bos` + `rate3_bos` + `rate4_bos` + `rate5_bos`
) /5 AS Average
FROM `boss_bos`
ORDER BY Average DESC;

No comments:

Post a Comment