"oj" <nospam_ojngo@home.com> wrote in message
news:uF3ZpXSnDHA.2528@TK2MSFTNGP12.phx.gbl...
> This will give you float values...
>
> select data,value1,
> value2=(select sum(value1) from (select top 3 value1 from tst t2 where
> t2.data<=t1.data order by data desc)x having count(*)=3)/3.,
> value3=(select sum(value1) from (select top 6 value1 from tst t2 where
> t2.data<=t1.data order by data desc)x having count(*)=6)/6.
> from tst t1
>
> --
> -oj
> RAC v2.2 & QALite!
> http://www.rac4sql.net
>
>
>
>