某列中每个值与其前一个值的差异及结果显示
原文英文,约300词,阅读约需1分钟。发表于: 。We have table SAMPLE in the Sybase database. The data is as follows: We are trying to calculate the difference of each REP value and its previous one and display values in the original order of...
在Sybase数据库中,为计算表SAMPLE中每个SECURITY_ID的REP值与前一天的差异,我们使用自连接实现。相比之下,开源的esProc SPL支持有序集合,简化了相邻值计算。