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
from T A,(SELECT ROWNUM+9 FROM DUAL WHERE 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.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
from T A,(SELECT ROWNUM+9 CODE FROM DUAL CONNECT BY ROWNUM+9<=
(SELECT MAX(gradecode) FROM T))B
WHERE A.gradecode>=B.CODE
表T 字段 N 4条记录10~13
测试语句
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 13
前几年回帖都是只要给出思路就够了,现在给出基本代码都不行,真头疼
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