怎样得到列之和啊? 搞定了。。select sum(G_Number) from User_GroupList where Uid="+Uid 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1.在告诉你一个通用的方法:select uid,sum(number) sumfrom User_GroupListwhere Uid=1group by uid 2.如果想统计每个uid的number的和select uid,sum(number) sumfrom User_GroupListgroup by uid 用分組求和就行select sum(number) as [sum]from tablenamegroup by uidselect sum(number) as [sum]from tablenamewhere uid=1 要將uid一列所有數加起來怎麼辦? 如何修改这个sql 还是发个字符转日期的问题 域内无法访问SQLServer服务器 在线等待!!!重复数据的问题,急急!! 关于email的数据库设计,我只知道一些基本的字段,希望大家给我点建议。 会出现这样一个问题? 数据运算问题 求SQL语句一段~ 请教:两张表的组合查询问题 Reporting Service打开WMI报错 Excel导入到SQL!!!!!!急! 在线等!谢谢 ???????????插入表变量的数据源问题,在线等待,急!
在告诉你一个通用的方法:
select uid,sum(number) sum
from User_GroupList
where Uid=1
group by uid
select uid,sum(number) sum
from User_GroupList
group by uid
select sum(number) as [sum]
from tablename
group by uidselect sum(number) as [sum]
from tablename
where uid=1