安卓模拟器可以用手柄:SQL查询问题

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/06 01:17:53
表A有 列B 和 列C
B为 名称 C 是 数量(整数)
B有重复
现在要查每种B的的C的求和
SQL语句应该怎样??

select B,sum(C)
from A
group by B

select B,sum(C) as num from A group by B

查询语句
select B,sum(C) as num from A group by B

显示语句
response.write rs(1)

select B,sum(C)
from A
group by B