IT分销/经销数据库
能用sql实现吗？请求db2高人得帮助
表1acctno bal trandate --------------------------------------------102012011 81.23 2010-01-03102012...显示全部
查看其它 20 个回答ninth的回答
回复 16# zihowe
select acctno,bal,trandate1,
LEAD(trandate1,1,'2012-12-31')
OVER(ORDER BY trandate1) AS trandate2
from
(
values
(102012011,81.23,'2010-01-03'),
(102012011,100.21,'2010-01-05'),
(102012011,481.23,'2010-02-04'),
(102012011,1300.21,'2010-04-05'),
(102012011,281.23,'2010-04-07'),
(102012011,1020.21,'2010-05-01'),
(102012011,821.23,'2010-05-21'),
(102012011,100.21,'2010-05-26')
) as t(acctno,bal,trandate1)
select acctno,bal,trandate1,
LEAD(trandate1,1,'2012-12-31')
OVER(ORDER BY trandate1) AS trandate2
from
(
values
(102012011,81.23,'2010-01-03'),
(102012011,100.21,'2010-01-05'),
(102012011,481.23,'2010-02-04'),
(102012011,1300.21,'2010-04-05'),
(102012011,281.23,'2010-04-07'),
(102012011,1020.21,'2010-05-01'),
(102012011,821.23,'2010-05-21'),
(102012011,100.21,'2010-05-26')
) as t(acctno,bal,trandate1)
浏览765