oracle minus 不包含

来源:互联网 发布:熹妃传厨艺大赛软件 编辑:程序博客网 时间:2024/05/18 00:07
--已左边为基准不包括右边的,如下SELECT ROWNUM+2 FROM DUAL CONNECT BY ROWNUM <= 10 -- 3,4,5,6,7,8,9,10,11,12MinusSELECT ROWNUM FROM DUAL CONNECT BY ROWNUM <= 10 -- 1,2,3,4,5,6,7,8,9,10--查询出 11,12

 

0 0