table: income 日期 dt 客户名 name 日合计收入 dayin 日合计支出 dayoutselect dt,name,dayin,dayout,(select sum(dayin-dayout) from income where name=a.name and dt<=a.dt) net_income from income a order by dt,name
table: income 日期 dt 客户名 name 日合计收入 dayin 日合计支出 dayoutselect dt,name,dayin,dayout,(select sum(dayin-dayout) from income where name=a.name and dt<=a.dt) net_income from income a order by dt,name
declare @int_yue set @int_yue = ???select A.日期, A.客户名, @int_yue+sum(B.日合计收入)-sum(B.日合计支出) as 净余额 from tablename as A, tablename as B where A.日期 >= B.日期 and A.客户名 = B.客户名
日期 dt
客户名 name
日合计收入 dayin
日合计支出 dayoutselect dt,name,dayin,dayout,(select sum(dayin-dayout) from income where name=a.name and dt<=a.dt) net_income
from income a
order by dt,name
日期 dt
客户名 name
日合计收入 dayin
日合计支出 dayoutselect dt,name,dayin,dayout,(select sum(dayin-dayout) from income where name=a.name and dt<=a.dt) net_income
from income a
order by dt,name
set @int_yue = ???select A.日期, A.客户名, @int_yue+sum(B.日合计收入)-sum(B.日合计支出) as 净余额 from tablename as A, tablename as B
where A.日期 >= B.日期
and A.客户名 = B.客户名