Basics Blog
Total Pageviews
Wednesday, March 7, 2012
Average of multiple columns
Table name: `boss_bos`
rate1_bos
rate2_bos
rate3_bos
rate4_bos
rate5_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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment