表只用一列
ID
-----------
BEGDATE
ENDDATE
ITEMID
CURRID
CURRJE通过Select 如何得到
ID
-----------
BEGDATE,ENDDATE,ITEMID,CURRID,CURRJE
ID
-----------
BEGDATE
ENDDATE
ITEMID
CURRID
CURRJE通过Select 如何得到
ID
-----------
BEGDATE,ENDDATE,ITEMID,CURRID,CURRJE
调试欢乐多
FROM (SELECT colb, colc, LEAD (colc) OVER (ORDER BY colc) cold
FROM (SELECT colb, ROW_NUMBER () OVER (ORDER BY colb) colc
FROM (SELECT ID AS colb
FROM tab1)))
START WITH cold IS NULL
CONNECT BY PRIOR colc = cold
connect by rownum<6
from (select rownum id,字段名 rowname,lead(rownum) over(order by rownum desc) id1
from 表名)
start with id1 is null
connect by prior id=id1;