jboracle1981 发表于 2013-3-18 21:42
分析函数
例如:last_value(xzqh)over(partition by jgdm order by id)
select id,last_value(xzqh)over(partition by jgdm order by id),jgdm,jgmc,zcsj from qy_info
这么应该实现不了啊?
sr19830207 发表于 2013-3-19 20:51
select id,last_value(xzqh)over(partition by jgdm order by id),jgdm,jgmc,zcsj from qy_info
这么应该 ...
select id,last_value(xzqh IGNORE NULLS)over(partition by jgdm order BY ID),jgdm,jgmc,zcsj from t