＋设为首页 ＋添加到收藏夹
数据库原始记录为
id name sum
1 A 10
2 B 16
3 C 5
4 A 23
5 B 1
希望产生以下记录集:
name sum
A 33
B 17
C 5
sql语句怎么写,另外在BCB中怎么使用记录集?
谢谢
select name, sum(sum) from DATANAME group by count(name)
select name,sum([sum]) from table group by name
select name,sum([sum]) from table1 group by name
use ado
in VB
Dim cn As New ADODB.Connection
Dim rs As ADODB.Recordset
. . .
cmd1 = txtQuery.Text
Set rs = New ADODB.Recordset
rs.Open cmd1, cn
rs.MoveFirst
. . .
Code to loop through result set(s)
bcb also
select name = name,
sum_amount =convert(decimal(16,3),sum(isnull(sum,0)))
from table_a
group by name
在定义字段名是最好不要取与SQL SERVER关键字如sum,id,name,date等
select [name],sum([sum])
from table1
group by [name]
