3,494
社区成员




select A.ID,B.CODE AS gradecode,A.XXXXX--表的其他字段
from T A,(SELECT ROWNUM+9 CODE FROM DUAL CONNECT BY ROWNUM+9<=
(SELECT MAX(gradecode) FROM T))B
WHERE A.gradecode>=B.CODE
ORDER BY A.ID,B.CODE
select A.*,B.CODE AS gradecode
from T A,(SELECT ROWNUM+9 CODE FROM DUAL CONNECT BY ROWNUM+9<=
(SELECT MAX(N) FROM T))B
WHERE A.N>=B.CODE
ORDER BY N,B.CODE
测试结果
N gradecode
10.00 10
11.00 10
11.00 11
12.00 10
12.00 11
12.00 12
13.00 10
13.00 11
13.00 12
13.00 13select A.ID,B.CODE AS gradecode
from T A,(SELECT ROWNUM+9 CODE FROM DUAL CONNECT BY ROWNUM+9<=
(SELECT MAX(gradecode) FROM T))B
WHERE A.gradecode>=B.CODE
select A.ID,B.CODE AS gradecode
from T A,(SELECT ROWNUM+9 FROM DUAL CONNECT BY ROWNUM+9<=
(SELECT MAX(gradecode) CODE FROM T))B
WHERE A.gradecode>=B.CODE
select A.*,B.CODE
from T A,(SELECT ROWNUM+9 FROM DUAL CONNECT BY ROWNUM+9<=
(SELECT MAX(gradecode) CODE FROM T))B
WHERE A.gradecode>=B.CODE
select A.*,B.CODE
from T A,(SELECT ROWNUM+9 FROM DUAL WHERE ROWNUM+9<=
(SELECT MAX(gradecode) CODE FROM T))B
WHERE A.gradecode>=B.CODE