sqlserver 2000:
SELECT SUM(rn) AS Expr1
FROM (SELECT (SELECT COUNT(*)
FROM sysobjects
WHERE id < a.id) AS rn
FROM sysobjects a) b
WHERE (rn <= 100) AND (rn % 2 <> 0)
结果是2500.
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024