3,491
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE T113
(
ID VARCHAR2(20),
Age NUMBER(4),
NAME VARCHAR2(20)
);
INSERT INTO T113 VALUES('01', 8, 'A');
INSERT INTO T113 VALUES('02', 9, 'B');
INSERT INTO T113 VALUES('03', 16, 'C');
INSERT INTO T113 VALUES('04', 20, 'D');
INSERT INTO T113 VALUES('05', 30, 'E');
INSERT INTO T113 VALUES('06', 25, 'F');
INSERT INTO T113 VALUES('07', 65, 'G');
INSERT INTO T113 VALUES('08', 67, 'H');
INSERT INTO T113 VALUES('09', 66, 'I');
(select rownum rn from dual connect by rownum<=65)
minus
(select rownum rn from dual connect by rownum<16)