Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

1.資料表如下:

OPTD_N
--------------
交易日期
---------------
2008-01-02
2008-01-03
2008-01-04
2008-01-07

2.希望達成的顯示方式:

交易日期 次一個交易日
---------------------
2008-01-02 2008-01-03
2008-01-03 2008-01-04
2008-01-04 2008-01-07
2008-01-07 2008-01-08

 

方法:

select m.date1,n.date1 from (select date1,row_number() over (order by date1) as tt from date1 ) m
left join
(select date1,row_number() over (order by date1) as ff from date1 ) n
on m.tt=n.ff-1;

 

其中row_number() over的方法參考:

http://blog.yam.com/camuschou/article/14722883