第1个回答 2014-01-12
DECLARE @x INT, @sum INT,@s INT
SET @x=1
SET @sum=0
SET @s=0
WHILE @x<=100
BEGIN
if @x%3=0
BEGIN
SET @sum = @sum+ @x
SET @s=@s+1
END
SET @x=@x+1
END
SELECT @x as 总和,@s as 个数
第2个回答 2014-01-13
SELECT
number
FROM
master..spt_values
WHERE
type='P'
AND number between 1 and 100
AND number % 3 = 0
GO
number
-----------
3
6
9
12
15
18
21
24
27
30
33
36
39
42
45
48
51
54
57
60
63
66
69
72
75
78
81
84
87
90
93
96
99
(33 行受影响)
本回答被提问者采纳
第3个回答 2014-01-12
DECLARE @x INT, @sum INTSET @x=1SET @sum=0WHILE @x<101BEGIN if @x%3=0 BEGIN SET @sum = @sum+ @x END SET @x=@x+1END SELECT @x
第4个回答 2014-01-12
with t(n) as (select 1
union all
select n+1 from t where n<100)
select count(*), sum(n)
from t
where n%3=0本回答被网友采纳