WITH T AS
(SELECT ROWNUM RN FROM DUAL CONNECT BY LEVEL < 100)
SELECT RN
FROM T
WHERE RN > 1
MINUS
SELECT A.RN * B.RN
FROM T A, T B
(SELECT ROWNUM RN FROM DUAL CONNECT BY LEVEL < 100)
SELECT RN
FROM T
WHERE RN > 1
MINUS
SELECT A.RN * B.RN
FROM T A, T B
WHERE A.RN <= B.RN AND A.RN > 1 AND B.RN > 1;
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
