李颖 · 2004-12-24 04:17:55 · 阅读: 514 .. select id, jie, dai, (select sum(jie) - sum(dai) from xxx as Tab2 where id < Tab1.id) as yue from xxx as Tab1 order by id