求一sql语句。在线等,立即给分 数据表a b c1 1 15 3 73 8 9想得到的结果集a b c1 1 15 3 73 8 99 12 17注:最后一行为上面所有列的和谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from tbunion allselect a = sum(a) , b= sum(b) , c = sum(c) from tb select a,b,c from 数据表union all selectsum(a) as a,sum(b) as b,sum(c) as cfrom 数据表 select * from tablenameunion allselect sum(a),sum(b),sum(c) from tablename create table tb(a int, b int, c int)insert into tb values(1 , 1 , 1 )insert into tb values(5 , 3 , 7 )insert into tb values(3 , 8 , 9 )goselect * from tb union all select a = sum(a) , b= sum(b) , c = sum(c) from tbdrop table tb/*a b c ----------- ----------- ----------- 1 1 15 3 73 8 99 12 17(所影响的行数为 4 行)*/ select * from tb union all select sum(a) , sum(b) , sum(c) from tb select * from tbunion allselect a = sum(a) , b= sum(b) , c = sum(c) from tb 存储过程所得数据导入access数据库 一个分组查询问题 c/s应用中,客户端不定期出现非常慢的现象。 SQL能不能将一行数据分几行显示 小弟求教———怎样找到网络中已有的sql服务?甩分了! 触发器触发进程的问题,解决了100分相赠! 请问出现以下请示,如何设置ODBC 还是修改其它地方。ACCESS数据库 SQL SERVER 多字段、多表关联无返回的问题? 请教高手,关于在Linux RedHat 下安装ODBC. 存儲過程的問題 怎末设置一个登录名登陆后只能看到其可访问的数据库? 新手报道,向大师们学习。
union all
select a = sum(a) , b= sum(b) , c = sum(c) from tb
union all
select
sum(a) as a,
sum(b) as b,
sum(c) as c
from 数据表
union all
select sum(a),sum(b),sum(c) from tablename
insert into tb values(1 , 1 , 1 )
insert into tb values(5 , 3 , 7 )
insert into tb values(3 , 8 , 9 )
goselect * from tb
union all
select a = sum(a) , b= sum(b) , c = sum(c) from tbdrop table tb/*
a b c
----------- ----------- -----------
1 1 1
5 3 7
3 8 9
9 12 17(所影响的行数为 4 行)*/
union all
select sum(a) , sum(b) , sum(c) from tb
union all
select a = sum(a) , b= sum(b) , c = sum(c) from tb