sql求S=1+1/2*2+1/3*3......+1/100*100
答案:2 悬赏:80 手机版
解决时间 2021-03-20 20:07
- 提问者网友：孤山下
- 2021-03-20 02:33
sql求S=1+1/2*2+1/3*3......+1/100*100
最佳答案
- 五星知识达人网友：妄饮晩冬酒
- 2021-03-20 02:40
declare @S float,@I int
set @I=1
set @S=0
while @I<=100
begin
set @S=@S+1.0/(@I*@I)
set @I=@I+1
end
print @S追问完整点
set @I=1
set @S=0
while @I<=100
begin
set @S=@S+1.0/(@I*@I)
set @I=@I+1
end
print @S追问完整点
全部回答
- 1楼网友：孤独入客枕
- 2021-03-20 02:52
;with temp as
(select cast(1 as float) as lvl, cast (0.0000 as float) as num
union all
select lvl+1,1/(lvl*lvl)
from temp
where lvl<=100
)
select sum(num) from temp
---里面是有括号的吧？1/(3*3)?
(select cast(1 as float) as lvl, cast (0.0000 as float) as num
union all
select lvl+1,1/(lvl*lvl)
from temp
where lvl<=100
)
select sum(num) from temp
---里面是有括号的吧？1/(3*3)?
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯