7,786
社区成员
发帖
与我相关
我的任务
分享取sql server查询结果？
有一如下查询：
select xm,sum(sl) from xs
group by xm
order by xm
compute sum(sl)
该如何在VB或Delphi中取得其合计值？
select xm,sum(sl) from xs
group by xm
order by xm
compute sum(sl)
该如何在VB或Delphi中取得其合计值？
...全文
请发表友善的回复…
发表回复
cqq_chen 2001-04-05
- 打赏
- 举报
在VB中你可以用以下方式取值。
dim db as database
dim sc as recordset
'db为当前数据库。
sc=db.OpenRecordset
("select xm,sum(sl) from xs group by xm order by xm compute sum(sl)")
dim x as integer
x=sc.Fields(2)
dim db as database
dim sc as recordset
'db为当前数据库。
sc=db.OpenRecordset
("select xm,sum(sl) from xs group by xm order by xm compute sum(sl)")
dim x as integer
x=sc.Fields(2)
寒星 2001-04-05
- 打赏
- 举报
对，如：select xm,sum(sl) as total from xs ...
只要引用total可以了。
只要引用total可以了。
xtra 2001-04-04
- 打赏
- 举报
你给SUM（SL）字段起个别名，然后引用它就行了。
如果查询的结果某个字段是Null，用默认的值代替。
1、）Sql server中：
select case when 字段名1 is null
then 替代值
else 字段名1
end +
...
