YAN HONG YE <yanhong...@mpsa.com> wrote:
> select round(((select avg(close) from test2 b where b.tkid between a.tkid-12
> and a.tkid) -
> (select avg(close) from test2 b where b.tkid between a.tkid-26 and
> a.tkid)),2) from test2 a
>
> could be select the result,but when update use this sql script:
>
> update test2 set diff =(select round(((select avg(close) from test2 b where
> b.tkid between a.tkid-12 and a.tkid) -
> (select avg(close) from test2 b where b.tkid between a.tkid-26 and
> a.tkid)),2) from test2 a)
>
> all of the result is 0
update test2 set diff = round(
(select avg(b.close) from test2 b where b.tkid between test2.tkid-12 and
test2.tkid) -
(select avg(b.close) from test2 b where b.tkid between test2.tkid-26 and
test2.tkid)
, 2);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
