------解决思路----------------------
select satff-no,count(c1)
from a
group by satff-no
------解决思路----------------------
暂时想到这种，试下
SELECT *,
(SELECT SUM(C1) FROM A WHERE staff_no = a1.staff_no AND dates <= a1.dates)
FROM A AS a1
详细解决方案
！ sql应用 同一张表更新表字段
热度：91 发布时间：2016-04-24 09:24:35.0
------解决思路----------------------
select satff-no,count(c1)
from a
group by satff-no
------解决思路----------------------
暂时想到这种，试下
相关解决方案