--已左边为基准不包括右边的,如下
SELECT ROWNUM+2 FROM DUAL CONNECT BY ROWNUM <= 10 -- 3,4,5,6,7,8,9,10,11,12
Minus
SELECT ROWNUM FROM DUAL CONNECT BY ROWNUM <= 10 -- 1,2,3,4,5,6,7,8,9,10
--查询出 11,12
--已左边为基准不包括右边的,如下
SELECT ROWNUM+2 FROM DUAL CONNECT BY ROWNUM <= 10 -- 3,4,5,6,7,8,9,10,11,12
Minus
SELECT ROWNUM FROM DUAL CONNECT BY ROWNUM <= 10 -- 1,2,3,4,5,6,7,8,9,10
--查询出 11,12