oracle中用lead构造"缺衣少食"

SELECT rn, lead(rn) over(order by rn) next01, lead(rn,2) over(order by rn) next02, lead(rn,3) over(order by rn) next03, lead(rn,4) over(order by rn) next04, lead(rn,5) over(order by rn) next05, lead(rn,6) over(order by rn) next06, lead(rn,7) over(order by rn) next07 FROM ( SELECT rownum+1 rn FROM dual CONNECT BY rownum < 9) t

 

2 3 4 5 6 7 8 9 
3 4 5 6 7 8 9  
4 5 6 7 8 9   
5 6 7 8 9    
6 7 8 9     
7 8 9      
8 9