declare @num int
declare @i int
set @num=1
set @i=0
begin
while @num<=19
begin
set @i=@i+@num
set @num=@num+2
end
print @i
end
declare @i int
set @num=1
set @i=0
begin
while @num<=19
begin
set @i=@i+@num
set @num=@num+2
end
print @i
end
温馨提示：内容为网友见解，仅供参考
第1个回答 2013-10-31
SELECT SUM(RN)
FROM
(SELECT rownum rn FROM dual CONNECT BY rownum<=19
)
WHERE mod(rn,2)=1;追问
FROM
(SELECT rownum rn FROM dual CONNECT BY rownum<=19
)
WHERE mod(rn,2)=1;追问
by附近有错误是什么情况呢
相似回答
大家正在搜
