SQL代码计算1-100内能被3整除或者能被5整除的所以整数的平方和,并打印输出求

Question

如题所述

Answer 1

以下是使用SQLSERVER 的 SQL 代码计算 1-100 内能被 3 整除或者能被 5 整除的所有整数的平方和，并将结果打印输出：
DECLARE @sum INT = 0; -- 计算能被 3 整除的整数的平方和SELECT @sum = @sum + POWER(number,
2)
FROM
(SELECT number = ROW_NUMBER()
OVER (ORDER BY
(SELECT NULL)) - 1
FROM master..spt_values ) AS numbers
WHERE number
BETWEEN 1
AND 100
AND number % 3 = 0; -- 计算能被 5 整除的整数的平方和SELECT @sum = @sum + POWER(number,
2)
FROM
(SELECT number = ROW_NUMBER()
OVER (ORDER BY
(SELECT NULL)) - 1
FROM master..spt_values ) AS numbers
WHERE number
BETWEEN 1
AND 100
AND number % 5 = 0; -- 打印输出结果
PRINT '1-100内能被3整除或者能被5整除的所有整数的平方和: ' + CAST(@sum AS VARCHAR);
以下是使用MYSQL的脚本来实现：
SELECT SUM(number * number) AS sum_of_squares
FROM
(SELECT @row_num := @row_num + 1 AS number
FROM
(SELECT 0
UNION
SELECT 1
UNION
SELECT 2
UNION
SELECT 3) a,

(SELECT 0
UNION
SELECT 1
UNION
SELECT 2
UNION
SELECT 3) b,

(SELECT @row_num := 0) init
WHERE @row_num < 100 ) numbers
WHERE number % 3 = 0
OR number % 5 = 0;