没有现成函数,但可以用SQL累加: select id,(select sum(value) from t where id<=a.id) 累加值 from t a order by a.id
to:pbsql(风云) 你查询的结果出现错误,如下: --------------------------- Microsoft Development Environment --------------------------- sum or average aggregate 运算不能以 char 数据类型作为参数。 --------------------------- 确定 帮助 ---------------------------
我只是举个例子,你实际应用时sum(value)里的字段value当然得是数字型
转换一下即可sum(cast(value as int))
如下面: SELECT d.AssetParameter FROM Asset d,AssetToMass e,AssetStyle f WHERE f.AssetStyle='主板' AND f.AssetStyleId=d.AssetStyleId AND d.AssetId=e.AssetId AND e.AssetMassId=a.AssetMassID 这个子查询的结果可能是多条记录,但我希望将多条记录的"AssetParameter"连接起来,成为"MainBoard"SELECT (SELECT d.AssetParameter FROM Asset d,AssetToMass e,AssetStyle f WHERE f.AssetStyle='主板' AND f.AssetStyleId=d.AssetStyleId AND d.AssetId=e.AssetId AND e.AssetMassId=a.AssetMassID ) AS MainBoard FROM AssetMass a,userDepartment b,AssetMassState c WHERE a.AssetMassBit=1 AND a.UseDeptID=b.departid AND a.AssetMassStateId=c.AssetMassStateID
SELECT d.AssetParameter FROM Asset d,AssetToMass e,AssetStyle f WHERE f.AssetStyle='主板' AND f.AssetStyleId=d.AssetStyleId AND d.AssetId=e.AssetId AND e.AssetMassId=a.AssetMassID主要是我不知上面我能查到几条记录啊.
select id,(select sum(value) from t where id<=a.id) 累加值
from t a order by a.id
你查询的结果出现错误,如下:
---------------------------
Microsoft Development Environment
---------------------------
sum or average aggregate 运算不能以 char 数据类型作为参数。
---------------------------
确定 帮助
---------------------------
SELECT d.AssetParameter FROM Asset d,AssetToMass e,AssetStyle f WHERE f.AssetStyle='主板' AND f.AssetStyleId=d.AssetStyleId AND d.AssetId=e.AssetId AND e.AssetMassId=a.AssetMassID
这个子查询的结果可能是多条记录,但我希望将多条记录的"AssetParameter"连接起来,成为"MainBoard"SELECT (SELECT d.AssetParameter FROM Asset d,AssetToMass e,AssetStyle f WHERE f.AssetStyle='主板' AND f.AssetStyleId=d.AssetStyleId AND d.AssetId=e.AssetId AND e.AssetMassId=a.AssetMassID ) AS MainBoard FROM AssetMass a,userDepartment b,AssetMassState c WHERE a.AssetMassBit=1 AND a.UseDeptID=b.departid AND a.AssetMassStateId=c.AssetMassStateID