How to find the average value of specified field data in mysql
滿天的星座
滿天的星座 2017-05-18 10:52:53
0
1
879

Table price, field category, value 55, average field pi

category,pi
55 100
55 105
56 130
55 95
55 80
59 115
55 101
55 98

How to calculate the average value of field pi (data with category 55)

滿天的星座
滿天的星座

reply all(1)
阿神

select avg(pi) as pi_avg from price where category=55

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template