- SQL code
/*原始数据DayTime Result20110101 3.8920110101 2.2920110101 4.0320110101 2.5720110103 2.4620110103 3.8920110103 4.1720110103 2.3920110103 3.5620110107 1.3620110107 3.8220110107 2.5820110107 2.7620110107 4.51求：DayTime为20110101这一天Result的平均值。DayTime为20110103这一天Result的平均值。DayTime为20110107这一天Result的平均值。求个循环。*/
麻烦大家了。
------解决方案--------------------
- SQL code
SELECT avg(Result) FROM [table] group by DayTime