復雜的SELECT要求 復雜的SELECT要求

if object_id('t') is not null
drop table t
go
create table t(riqi varchar(8),shouru int,zhichu int)
insert into t select '2000/3/1',50,30
union select '2000/3/2',45,60
union select '2000/3/5',60,10
select * from t
select riqi as 日期,shouru as 收入,zhichu as 支出,余额=(select sum(shouru)-sum(zhichu) from t where riqi<=t1.riqi) from t t1

结果
日期 收入 支出 余额
-------- ----------- ----------- -----------
2000/3/1 50 30 20
2000/3/2 45 60 5
2000/3/5 60 10 55

（所影响的行数为 3 行）

2. select riqi as 日期,sum(shouru) as 收入,sum(zhichu) as 支出,余额=(select sum(shouru)-sum(zhichu) from t where riqi<=t1.riqi) from t t1 group by riqi

[此贴子已经被作者于2007-1-11 21:41:37编辑过]