34,590
社区成员
发帖
与我相关
我的任务
分享
select *
, (select sum(InCount-OutCount) from t1 as t2 where t1.BulletTypeEncoding=t2.BulletTypeEncoding and t2.id<=t1.id)
from t1
限定条件:按id排序,而且id没有重复。
SELECT 第二个字段,SUM(CAST(INCOUNT AS INT)) AS RK, SUM(CAST(OUTCOUNT AS INT)),KC=SUM(CAST(INCOUNT AS INT)) -SUM(CAST(OUTCOUNT AS INT)) FROM TABLE GROUP BY 第二个字段