IT分销/经销数据库
能用sql实现吗？请求db2高人得帮助
表1acctno bal trandate --------------------------------------------102012011 81.23 2010-01-03102012...显示全部
查看其它 20 个回答leo_wyn的回答
给你个olap 函数参考:
select accto, bal, trandate,
coalesce(
min(trandate) over
(partition by accto order by to_date(trandate, 'YYYY-MM-DD HH24:MI:SS') nulls last rows between 1 following and 1 following),
'2010-12-31 00:00:00'
) next_trandate
from table(values
(102012011, 81.23, '2010-01-03 00:00:00'),
(102012011, 100.21, '2010-01-05 00:00:00'),
(102012011, 481.23, '2010-02-04 00:00:00')
)
as t(accto, bal, trandate)
select accto, bal, trandate,
coalesce(
min(trandate) over
(partition by accto order by to_date(trandate, 'YYYY-MM-DD HH24:MI:SS') nulls last rows between 1 following and 1 following),
'2010-12-31 00:00:00'
) next_trandate
from table(values
(102012011, 81.23, '2010-01-03 00:00:00'),
(102012011, 100.21, '2010-01-05 00:00:00'),
(102012011, 481.23, '2010-02-04 00:00:00')
)
as t(accto, bal, trandate)
浏览723