求一解决方法！~~~~~~~~~~~~~

Question

t1表   rq            字段a
20050102           3
20050104           0
20050105           22
20050106           33
20050107           1
20050108           33
20050109           1要求就是求出字段a连续五天不为0时的平均值
这样的应该怎么实现！~~~~

Answer 1

select avg(a)
from (
select rq,a
from (select * from t1 where a>0 order by rq desc)
where rownum<6)