sum of all the multiples of 3 or 5 below 1000

Comment

0

SET NOCOUNT ON

DECLARE @tablenums TABLE (
	id INT
	,Num INT
	)
DECLARE @x INT
DECLARE @m INT
DECLARE @y INT = 1

BEGIN TRANSACTION

SET @x = 3
SET @m = 3

DELETE
FROM @tablenums

WHILE @x < 1000
BEGIN
	INSERT INTO @tablenums
	VALUES (
		@y
		,@x
		)

	SET @x = @x + @m
	SET @y = @y + 1
END

SET @x = 5
SET @m = 5

WHILE @x < 1000
BEGIN
	INSERT INTO @tablenums (
		id
		,num
		)
	VALUES (
		@y
		,CASE 
			WHEN (
					SELECT num
					FROM @tablenums
					WHERE num = @x
					) IS NULL
				THEN @x
			ELSE 0
			END
		)

	SET @x = @x + @m
	SET @y = @y + 1
END

COMMIT

SELECT Sum(num) sumnums
FROM @tablenums

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql sum

Share

Link to this answer
Share Copy Link

Contributed on Sep 07 2022

Emily Anderson

0 Answers Avg Quality 2/10

find the sum of all the multiples of 3 or 5 below 1000 python

Comment

5

nums = [3, 5]

result = 0
for i in range(0,1000):
    if i%3 == 0 or i%5 == 0:
        result += i

print(result)

Popularity 9/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: find python

Share

Link to this answer
Share Copy Link

Contributed on Jan 11 2021

Vivacious Vole

0 Answers Avg Quality 2/10

sum of all multiples of 3 and 5 below 100

Comment

1

c = list(range(1,100))

total = 0

for i in (c):
    if i % 3 == 0 or i % 5 == 0:
      total += i
print (total)

Popularity 9/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: python py

Share

Link to this answer
Share Copy Link

Contributed on Sep 11 2021

Dizzy Duck

0 Answers Avg Quality 2/10

sum of multiples of 5 from 1 to 100

Comments(1)

0

total = 0

for i in range(1, 100):
    if i % 3 == 0:
        total = total + i
print(total)

total1 = 0
for i in range(1, 100):
    if i % 5 == 0:
        total1 = total1 + i
print(total1)

Popularity 8/10 Helpfulness 2/10 Language python

Source: Grepper

Tags: python sum su

Share

Link to this answer
Share Copy Link

Contributed on Feb 13 2022

Excited Elk

0 Answers Avg Quality 2/10

If we list all the natural numbers below 10 that are multiples of 3 or 5, we get 3, 5, 6 and 9. The sum of these multiples is 23. Find the sum of all the multiples of 3 or 5 below 1000.

Comment

3

total_sum = 0
for i in range(1000):
    if (i%3 == 0 or i%5 == 0):
        total_sum = total_sum+i
print total_sum

Popularity 9/10 Helpfulness 1/10 Language python

Source: codereview.stackexchange.com

Tags: find

Share

Link to this answer
Share Copy Link

Contributed on May 02 2022

Nervous Narwhal

0 Answers Avg Quality 2/10

sum of all the multiples of 3 or 5 below 1000

Contents

More Related Answers