帆软报表SQL怎么写循环和判断，假如计算1-100偶数和，遇到20跳过
SELECT SUM(CASE WHEN n % 2 = 0 AND n != 20 THEN n ELSE 0 END) AS even_sum FROM (SELECT ROWNUM AS n FROM dual CONNECT BY LEVEL <= 100)
用存储过程
1min目标场景问卷
立即参与
