try something like the following, but it is not efficient (it is easier and more efficient to do the summation in your application):select xm,dates,jbgz+jj+buzhu as cur
, (select sum(jbgz+jj+buzhu) from gongzi t2 where t2.xm=t1.xm and t2.dates <= t1.dates) as total
from gongzi t1 order by xm, dates
, (select sum(jbgz+jj+buzhu) from gongzi t2 where t2.xm=t1.xm and t2.dates <= t1.dates) as total
from gongzi t1 order by xm, dates
解决方案 »
- 学生表里有id,name(可以重复),score ,datetime,每个学生最近一次考试的记录的sql怎么写?
- 怎样同Transact-SQL语句设置内存最小值和最大值??
- 安装SQL Sever 2005 后无法连接服务器
- 对数据集“DataZXZJ”执行查询失败。
- 请教如何选择该使用stored procedure还是function?
- 如何在表中插入一行以后自动插入下一行的主码?
- 能不能一个系统中同时装SqlServer7 和 2000
- 附加数据库 问题
- 声明一个cursor时,for后边可以是一个变量码?请教,急!!!!!!
- 如何让sql自动把一条记录当作一个邮件发出去,添加记录时触发
- 添加一登录同时给该账号赋予对某数据库的访问权的功能用sql脚本如何写?
- 函数和存储过程的区别
insert gongzi (xm,jbgz,jj,buzhu,dates) values ('dali',500,300,200,'2002-8-1')
insert gongzi (xm,jbgz,jj,buzhu,dates) values ('dali',500,200,200,'2002-9-1')
insert gongzi (xm,jbgz,jj,buzhu,dates) values ('dali',500,700,200,'2002-10-1')
insert gongzi (xm,jbgz,jj,buzhu,dates) values ('dali',700,400,200,'2002-11-1')
insert gongzi (xm,jbgz,jj,buzhu,dates) values ('dali',700,300,200,'2002-12-1')那要用:select xm 姓名,dates 发薪时间,jbgz+jj+buzhu 本期,(select sum(jbgz+jj+buzhu) from gongzi b where b.dates<=a.dates and a.xm=b.xm) from gongzi a