求SQL写法???(在线) insert table1 select sum(aa),sum(bb),sum(cc) from table1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select sum(aa),sum(bb),sum(cc) from table1 假如表中有一个字符字段:ee(char(10)),该如何处理??如:aa bb cc ee1 5 6 aa 3 7 8 bb求和,生成一条记录:4 12 14 bb insert table1 select sum(aa),sum(bb),sum(cc),MAX(ee) from table1 INSERT INTO Test1SELECT SUM(UserID) AS Expr1, SUM(IsSelect) AS Expr2,MAX(ee) AS Expr3FROM Test1 对不起 ,上面不对,是放在一个临时表Test1中去了,:( INSERT INTO Test1SELECT SUM(aa) AS aa, SUM(bb) AS bb,SUM(cc) AS cc,MAX(ee) AS eeFROM Test1 create proc name asdeclare @aa int,@bb int,@cc int,@ee char(10)select @aa=sum(isnull(aa,0)),@bb=sum(isnull(bb,0)), @cc=sum(isnull(cc,0)),@ee=max(ee) from table1insert table1 values( @aa,@bb,@cc,@ee) 有关sp_executesql 执行错误 的问题 在mssql中select之后@@rowcount不会有值吗? 那位哥哥帮帮忙 临时表和内存表差别 sql server 2005 输入法无效 高手们这样的相对定位字符串查找替换能实现吗 菜鸟一问:MsSql中存储文件没有条理性,层次性??? 高手进来,求SQL语句! 求数据合并的SQL语句!高手出手吧~~~ 快过年了﹐给大家拜个早年﹗顺便问个问题﹐来者有分﹗ SQL排序的最经典问题?在线及等!!!!!!!!!!!!!!1 怎么才能把日期给update进去。
如:
aa bb cc ee
1 5 6 aa
3 7 8 bb求和,生成一条记录:
4 12 14 bb
SELECT SUM(UserID) AS Expr1, SUM(IsSelect) AS Expr2,MAX(ee) AS Expr3
FROM Test1
SELECT SUM(aa) AS aa, SUM(bb) AS bb,SUM(cc) AS cc,MAX(ee) AS ee
FROM Test1
select @aa=sum(isnull(aa,0)),@bb=sum(isnull(bb,0)),
@cc=sum(isnull(cc,0)),@ee=max(ee)
from table1insert table1 values( @aa,@bb,@cc,@ee)